Hi All,
I have a table of about 120,000 records which are mostly chemical products all with 100 byte varchar for the 'name'. I've indexed the 'name' and looked at a lot of ideas on the web,but I can't really find a solution. It's taking about 20 seconds to retrieve a record that's an exact match, and longer if I use 'between' or something get a broader result set. If I run the query in phpmyadmin, the query finishes in less than a tenth of a second, so I don't think it's database or computer related. When I request the same record using the application I built in PHPMaker, it takes 20 or more seconds before the record is displayed in the grid once the Search is started. I'm trying to figure out what I could do to speed things up.
Any suggestions on what I could look into?
Thanks greatly,
Lyle