more info
Thanks for the reply. Here is the info that should have been in my first post:
MySQL 5.0.19-standard
Linux kernel 2.6.8-24-default
Athlon 64 2800+
3GB RAM
CREATE TABLE `results0047`
(
`query` int(11) NOT NULL,
`match` int(11) NOT NULL,
`score` float NOT NULL,
KEY `query` (`query`),
KEY `match` (`match`),
KEY `score` (`score`)
)
ENGINE=MyISAM
DEFAULT CHARSET=ascii COLLATE=ascii_bin;
CREATE TABLE `items`
(
`id` int(11) NOT NULL,
`url` text collate ascii_bin NOT NULL,
`state` enum('new', 'working', 'searched', 'loaded', 'updated', 'deleted', 'held', 'done') collate ascii_bin default 'new',
`node` int(11) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `state` (`state`),
KEY `node` (`node`),
KEY `url` (`url`(767))
)
ENGINE=MyISAM DEFAULT CHARSET=ascii COLLATE=ascii_bin;