7 May
2005
7 May
'05
5:10 p.m.
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