Need help to Optimize select query

March 20th, 2008, 04:39 AM

i hav a large mysql database... actually not that big too..
its 10.7 mb in size. but when i make a select query on the table using php, (there is only one table in the database and it contains 89,750 records) it takes around 40 secs to giv the result!!!( I'll be very thankfull if anyone cud help me out.
my table is created like this

CREATE TABLE IF NOT EXISTS `plants` (
  `PID` int(10) NOT NULL default '0',
  `SCI_NAME` varchar(255) NOT NULL default '',
  `COMMON` varchar(255) NOT NULL default '',
  `FAMILY` varchar(255) NOT NULL default '',
  PRIMARY KEY (`PID`)
)ENGINE=MyISAM DEFAULT CHARSET=latin1;

and i m executing this query

select distinct SCI_NAME from plants;

....THANKS IN ADVANCE for Suggestions n solutions

zeronexxx · December 23rd, 2008, 09:39 PM

add an other index to your database for the field SCI_NAME, i am not sure i hope it will improve a little bit to the performance.

Thanks