Thanks.
Changed the query to:
"SELECT TOP 5 medName FROM dbo.prescMeds WHERE (medName LIKE'" + q + "%') ORDER BY medName"
And it is running a good bit faster, it's still taking about 4 seconds to show suggestions though, do you have any other ideas on how to speed it up or is it really down to the size of the table?
Main Topics
Browse All Topics





by: kadabaPosted on 2009-09-18 at 04:13:13ID: 25364637
On a single key press instead of retrieving all 5k records, you could get lesser number of records.
You could do this in query itself limiting the number of records to be shown.