List view and resultsets

[kieran_rush]

I'm using a List view to obtain the results of a query in a stored procedure, to put them in the listview I use a RDOresultset and then a do until rs.oef, but as the datbase is growing the time to see the data is getting longer and longer.
Can you help me with this, I've been trying to optimize this but with no results, what can I do to load the data in less time????, is there another way to load the data instead of a resultset????... and faster of course...
If you want the code of this event please let me know, by the way the databse I'm using is SQL 7.0 and Visual Basic 5.0(SP3)
Thank you for your time and help
Regards

[Lothar Haensler]

IMHO you should use ADO instead of RDO to be uptodate.
It may even be faster.
Then, try the GetRows method of the recordset object. It also appeared to be faster in my tests.

Next, make it appear faster for the user by using asynchronous operations. That way, for the user it looks like the app is faster because he can see results very early and doesn't have to wait until all the rows are fetched and displayed.