[drupal-devel] history-table

[Gerhard Killesreiter]

On Sat, 7 May 2005, Dries Buytaert wrote:

> 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)

CREATE TABLE history (
  uid int(10) NOT NULL default '0',
  nid int(10) NOT NULL default '0',
  timestamp int(11) NOT NULL default '0',
  PRIMARY KEY (uid,nid)
) TYPE=MyISAM;

Not sure which indices we could add. Maybe locks will help?

Cheers,
	Gerhard