Hi,
My drupal site is really slow. It's on a shared host, so I installed Boost as a possible solution(it rocks too). I could get faster page loads after installing, and it worked for anonymous users well. But when I try to post content (/node/add/*) which has taxonomy enabled, I get "invalid argument for each()..." Error from taxonomy.Module. I couldn't figure out what went wrong. So I disabled Boost. Problem solved, low performance
In a test site(above's dump) with Boost enabled, I used devel to track sql queries. It shows that site spend hundreds of miliseconds dealing with cache tables.(14 times, 2sec)
any idea on what I can do is great.
Theme: acqua marina
Modules:
adv forum
account reminder
path auto
pagetitiles
nodewords
rules
views/panels/ctools
dhtml menu
Comments
If cache queries are your
If cache queries are your problem then they are probably using MyISAM which locks the entire table when a row is being updated/inserted/deleted. You can switch to InnoDB which uses row-level locking which avoids this, but if you are on shared hosting then your host might not support this.
With the foreach error, you might need to change Boost's cache clearing options. You may have a broken View or the like.
--
Dave Hansen-Lange
Director of Technical Strategy, Advomatic.com
Pronouns: he/him/his