Need help to Optimize select query
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