Re: faster search engine for fulltext search

"Octavian Rasnita" schreef:

CREATE TABLE `articles` (
`id_newspapers` smallint(3) unsigned NOT NULL default '0',
`id_sections` smallint(3) unsigned NOT NULL default '0',
`id` int(6) unsigned NOT NULL auto_increment,
[...]
PRIMARY KEY (`id_newspapers`,`id_sections`,`id`),

This is not a Perl question, please look for an appropriate newsgroup.

It is often better to have the auto_incremented "id" as the only column
in the PRIMARY KEY.

--
Affijn, Ruud

"Gewoon is een tijger."


.