I turned off the cache by commenting out the code, and the site went from SLOOOW to snappy immediately. The performance increase by turning off the cache was very very clear.
I'm not even sure it's because of that myisam "problem" you referred too.. my comment and node tables are still very large, and being hit a lot, but it is MUCH faster with the cache turned off.
Peter
On 8/6/06, Greg Knaddison - GVS Greg@growingventuresolutions.com wrote:
On 8/4/06, Peter Van Dijck petervandijck@gmail.com wrote:
recently upgraded to 4.6 Since then, the site became quite slow.
The cache table seems to be causing a lot of the slowness. I turned caching off in administer.settings, but the cache table is still being written to and being queried.
What leads you to believe this? The cache usually helps performance.
Unless you are being bit by this scenario, in which case the answer is well documented by Mr. Handelaar: http://drupal.org/node/43336
Regards, Greg
-- Greg Knaddison | Growing Venture Solutions Denver, CO | http://growingventuresolutions.com Technology Solutions for Communities, Individuals, and Small Businesses -- [ Drupal support list | http://lists.drupal.org/ ]