… be performance bottleneck, assuming PHP opcode cache is not used. Also different applications may have different cache hit …Performance tuning ? Not surpising associative array cache performs the best, almost 4 times faster than APC shared memory cache – closest competitor. In real life performance…
Comment: Cache Performance Comparison
August 4, 2009 By 73 Comments
… as a straight PHP call on the memory cache, but you can only access the memory cache from the local PHP process.  I… with APC as it is PHP specific.  For more information on performance and advice on when various caching methods may be more useful Peter over at MySQLPerformanceBlog has written an interest article Cache Performance…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 12 Comments
… a query in Memcache. When the cache “expires”, the contents must be fully recalculated…customer_id, customer_name, sale_when; $ php convert.php demo < sales.sql CALL flexviews.create('demo',... the difference in response time. Refresh method performance comparison For demonstration purposes, I did the…
Post: Database problems in MySQL/PHP Applications
August 11, 2006 By 12 Comments
… to performance critical queries if you need. I would also note for many PHP applications abstraction layer is not the main performance problem… well as much more queries per page which will make performance improvement much smaller. Notable exception being AJAX applications which may… work and formating, so database connection may become the issue. Caching should be good help in this case though. About Consulting…
Post: Caching could be the last thing you want to do
July 24, 2010 By 14 Comments
… for every performance problem, but in many cases it should not be your first choice. Here is why: Caching might not… has all the cache misses, which can make this problem even worse. Caching can reduce visibility – You look at the performance profile of….” – a quote from Justin’s slides on instrumentation-for-php. In terms of future-proofing design, many applications are…
Post: Wishes for new "Pure PHP" MySQL driver
October 28, 2006 By 17 Comments
…seen announcement by MySQL to develop pure PHP driver. If not – Here is FAQ . …to standard statements to check bugs and performance difference without changing my application. Also there…tracking same statements in your application and caching them. Persistent Connections Ajax applications with …
Post: Goal driven performance optimization
December 22, 2008 By Leave a Comment
… as the main factor because sphinx and MySQL respond from cache. We however see for pages which have the problem it… know what performance gain potential is. For example in this case we could spend a lot of time optimizing PHP code but… mention looking at performance statistics for the day overall is often not enough. Application performs as good as it performs during its worst…
Post: Caching techinques
August 8, 2006 By 11 Comments
… ofload sending cache result to the client by web server (instead of doing it from PHP). The other case when caching in files can be very helpful is caching data long term – ie… downsides – you have to perform extra version check on each lookup and it might be complicated and caching bugs hard to debug…
Comment: Cache Performance Comparison
September 15, 2007 By 73 Comments
[...] Cache Performance Comparison – MySQL, Memcached, and various PHP caches [...]
Comment: Cache Performance Comparison
April 1, 2008 By 73 Comments
[...] PHP & Mysql Cache Performance Comparison [...]
