I’m looking at testing the new developments that Magento plan to release in version 4, but I need a few sizable databases to test the new speeds etc with.
My own test bases generally range up to 1000 products, 30 attributes. So if anyone has higher and wishes to help-out by lending me their database … Read on Squire

Anyone who already knows me knows I have a ridiculous amount of books; mostly e-books thesedays (the future-wifey takes exception to a book-based house-invasion) and mostly for reference. I am by all definition a book whore.  So when PACKT offered to send me their latest so I can review it and didn’t stipulate any real … Read on Squire

Ever wondered why Magento Layered Cache Was SOOOO Slow and Greedy, as in it sees mysql as its bitch and likes to consume as much resource as humanly possible.

This is a SINGLE update query based on my test 'footwear' store, several attributes etc. Course the more attributes you have the slower it goes.

PHP-CLI Edition
* Auto Product Count
* Auto On Completion Destroy Temp Files
* Various Optimizations

*NEW* PHP Web Browser Edition
* Three files;
* Wrapper (which you run from your browser)
* Two IFRAMES: The main functional script and a counter to show its not fallen asleep

Solution 2 – Running the Layered Navigation Cache in bits from PHP-CLI
Part Three Solves a lot (GO BADGER)

So not everyone has half a gig of ram to play with, that’s a git. Funnily though, I don’t have PS on the server I’m developing Magento on (why, oh god why?) so I cant build a shareable … Read on Squire

When running a cache refresh on Layered Navigation the script times out producing either an Error 500 or server based error. The problem is then made worse by magento's failure to recognise that the process didn't complete.