Optimising date filtered SQL queries
Explains how to optimize SQL query performance by avoiding functions in WHERE clauses, using date filtering as a key example.
Explains how to optimize SQL query performance by avoiding functions in WHERE clauses, using date filtering as a key example.
Performance comparison of three methods for sorting in-memory DataTables in C#/.NET, with LINQ to DataSet emerging as the fastest.
A developer shares their anticipation and planned schedule for the QCon London 2010 conference, focusing on architecture, .NET, and scalability.
Explains the importance of clearing SQL Server's data and execution plan caches for fair query performance comparisons during tuning.
Analysis of Facebook's HipHop PHP compiler, discussing its design, performance goals, and limitations compared to dynamic language implementations.
A technique to preload JS and CSS files as print stylesheets to improve page load times, with a warning about Chrome compatibility issues.
Explains an Unladen Swallow optimization for CPython, replacing METH_O/NOARGS with METH_FIXED to speed up calls to built-in functions with fixed arguments.
A historical look at JavaScript string manipulation, comparing the performance of split/join versus replace() for find-and-replace operations.
A technical article discussing a JavaScript method to dynamically load and manage CSS dependencies in large web applications.
Explains how optimizing compilers allow programmers to write clean, maintainable code without sacrificing performance, using examples like inlining and constant propagation.
Debunks common myths about the fsync() system call in Linux, explaining its importance for data durability and addressing performance concerns.
A technical deep dive into improving ext4 filesystem performance by optimizing the allocator to reduce e2fsck pass2 times.
Comparing JavaScript type-checking methods, showing that elegant, short code isn't always the fastest, with performance benchmarks.
Article compares ext4 vs ext3 filesystem check (fsck) speeds, showing ext4 is significantly faster based on real-world laptop tests.
Analysis of Twitter's frontend code, noting use of multiple JavaScript libraries and asset hosting strategies for high-traffic sites.
A transcribed talk defending dynamic languages, discussing their performance, tools, history, and evolution in software development.
Explains when to use ES6 Sets vs Arrays in JavaScript, focusing on performance, uniqueness, and use cases like error tracking and UI rendering.