[drupal-devel] Fwd: history-table

[Dries Buytaert]

Begin forwarded message:

> From: Dries Buytaert <dries at buytaert.net>
> Date: Sat 7 May 2005 13:45:43 CEST
> To: drupal-devel at drupal.org
> Subject: [drupal-devel] history-table
> Reply-To: drupal-devel at 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/