Begin forwarded message:
From: Dries Buytaert <dries@buytaert.net> Date: Sat 7 May 2005 13:45:43 CEST To: drupal-devel@drupal.org Subject: [drupal-devel] history-table Reply-To: drupal-devel@drupal.org
From profiling drupal.org, it seems that updating entries in (or inserting entries into) the history-table can be quite slow. Turns out the table it pretty big, so I'm not sure it is missing an index or two.
mysql> select count(*) from history; +----------+ | count(*) | +----------+ | 123805 | +----------+ 1 row in set (0.00 sec)
I spent the past 2 days keeping an eye on this, and it is certainly a performance bottleneck. Querying or updating the history table takes 6 ms whereas other SQL queries take about 0.2 - 0.3 ms on average. That is, we can do 20 to 30 other SQL queries in 6 ms. Something to think about. -- Dries Buytaert :: http://www.buytaert.net/