article thumbnail

Matching Supply With Demand — Solutions, Part 3

SQL Performance

Auctions ( Code , ID ) INCLUDE ( Quantity ) ; -- Enable batch-mode Window Aggregate. Auctions ( ID ) WHERE ID = - 1 AND ID = - 2 ; When describing the logic behind the solutions, I’ll assume the Auctions table is populated with the following small set of sample data: ID Code Quantity -- -. Code = 'D'. )

C++ 138
article thumbnail

Increase the Performance of your Site with Lazy-Loading and Code-Splitting

Jos

We are explicit about our dependencies, so we know what code we need to run to run a specific component. Lazy-loading and bundle splitting can have a huge impact on page performance: less code requested, parsed, and executed. When you send the user code that is not needed, you waste resources from your end, and from the user’s end.

Code 147
Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Trending Sources

article thumbnail

Matching Supply With Demand Challenge

SQL Performance

The challenge involves querying a table called Auctions, which you create using the following code: DROP TABLE IF EXISTS dbo. ( ID INT NOT NULL IDENTITY ( 1 , 1 ) CONSTRAINT pk_Auctions PRIMARY KEY CLUSTERED , Code CHAR ( 1 ) NOT NULL. Demand entries are marked with the code D and supply entries with S.

C++ 133
article thumbnail

Increase the Performance of your Site with Lazy-Loading and Code-Splitting

Jos

We are explicit about our dependencies, so we know what code we need to run to run a specific component. Lazy-loading and bundle splitting can have a huge impact on page performance: less code requested, parsed, and executed. When you send the user code that is not needed, you waste resources from your end, and from the user’s end.

Code 130
article thumbnail

CMake: The Case When the Project's Quality Is Unforgivable

DZone

This system is much older than the PVS-Studio static code analyzer, but no one has tried to apply the analyzer on its code and review the errors. CMake is a cross-platform system for automating software building from source code. The first release of the program took place in 2000. The CMake audience is huge.

article thumbnail

Cómo mejorar la performance de una web usando lazy-loading y code-splitting

Jos

Code Splitting y CSS-in-JS : cómo CSS-in-JS nos permite extender el code-splitting y lazy-loading a CSS, SVGs y otros recursos. animationDuration = 2000 ; this. La solución se basa en code splitting. Code Splitting y CSS-in-JS Hasta ahora hemos visto cómo usar un HOC para detectar que un elemento está en el viewport.

Code 130
article thumbnail

Powering the Web: Two Decades of Open Source Publishing With WordPress and MySQL

Percona

MySQL was founded in 1995 and went open source in 2000. MySQL was the database for phpWebLog, for example, way back in 2000. It wasn’t just free, as in beer; it demonstrated the benefits of having access to source code. But WordPress brought MySQL and open source to the masses. Note that I said values.