performance – Page 54 – Türker Yıldırım

MongoDB indexes are not free just because the schema is

NoteSeptember 30, 20132 min read

The pitch for a document store is that you can add a field without a migration, and that part is true. It gets read as “no schema, no…

yield turns a 500 MB export into a stream

NoteSeptember 24, 20132 min read

A method that builds an array of rows and returns it holds the entire result set in memory at once. A product export that was comfortable at 20,000…

Check whether OPcache is enabled

SnippetAugust 27, 20131 min read

OPcache ships with 5.5 and is off until you enable it

NoteJuly 16, 20132 min read

PHP 5.5 bundles Zend OPcache and does not enable it. A server that was running APC for its opcode cache and got upgraded in place therefore ends up…

Delete all Redis keys matching a pattern

SnippetMay 20, 20131 min read

CSS transitions are cheaper than animating with jQuery

NoteApril 23, 20132 min read

$.animate() runs a timer, writes an inline style on every tick and reads the layout back to work out the next one. The browser is doing the same…

Detect when an image has finished loading

SnippetApril 3, 20131 min read

Indexing a report query that reads the whole orders table

Deep diveMarch 7, 20139 min read

A daily report scanning 1.2 million rows to return two hundred. Why neither obvious index helped, what the composite one costs, and the two answers I turned down.

Cache the result of an expensive function in APC

SnippetNovember 29, 20121 min read

Swapping Apache and mod_php for nginx and PHP-FPM

Deep diveOctober 23, 201216 min read

512 MB, 150 concurrent visitors, and a box that swaps before the CPU is busy. Replacing Apache and mod_php with nginx and PHP-FPM, in three stages that each…