I have a 13 GB MYSQL table with the following definition:
CREATE TABLE WikiParagraphs
( ID
int(10) unsigned NOT NULL auto_increment, Paragraph
text NOT NULL, PRIMARY KEY (ID
)) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=73035281 ;
I query it like this:
select Paragraph from WikiParagraphs where ID in (1,2,3,4)
the 1,2,3,4 bit comes from the Sphinx FullText engine that gives me the IDs I need that match my query within about 500 milliseconds.
But retrieving the data itself takes approximately 3-6 seconds.
Obviously, I’d like to speed this query up.
Any ideas?