I am using VB as front end and MS Access as backend. When i am retrieving records from the database, its taking too long (30 - 40 seconds when there are some 8000 records). I came to know that the order by clause is causing it so much time. But order by is required ( a must ). So how can i go about with it. This is an urgent requirment. So, please someone help me. I would apreciate any kind of help from anyone.
Thanking you all in advance.
Mahesh