Re: Help optimizing query

2004-11-23 Thread Jesse Sheidlower
On Tue, Nov 23, 2004 at 09:55:15PM +0100, [EMAIL PROTECTED] wrote: > * Jesse Sheidlower > [...] > > CREATE TABLE `citation_subject` ( > > `id` int(11) NOT NULL auto_increment, > > `citation_id` int(11) NOT NULL default '0', > > `subject_id` int(11) NOT NULL default '0', > > PRIMARY KEY (`i

Re: Help optimizing query

2004-11-23 Thread roger
* Jesse Sheidlower [...] > CREATE TABLE `citation_subject` ( > `id` int(11) NOT NULL auto_increment, > `citation_id` int(11) NOT NULL default '0', > `subject_id` int(11) NOT NULL default '0', > PRIMARY KEY (`id`), > KEY `citation_id` (`citation_id`,`subject_id`) > ) Try adding an index