12 Jul
2006
12 Jul
'06
1:04 a.m.
Gerhard, One more note here, is that all this is MySQL centric. What about PostgreSQL? Its caching is different, and optimizing for one type of database will not apply. I think even Inno-DB (or the upcoming SOLID) caching will be different than MyISAM. I think two things can be explored further. 1. Revisit the file caching patch by Jeremy Andrews. 2. Look into object caches, like memcached, if the database is a bottleneck.