 13GB DB - Performance Question [message #1295] |
Wed, 23 May 2007 16:22  |
 GeoffreyF67
Messages: 21
Registered: May 2007 |
Junior Member |
|
|
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?
G-Man
|
|
|
Members
Search
Help
Register
Login
Home
