I've got a web server with ASPs that connect to a very remote database server (SQL Server, WAN link ping response times around 200 ms) and d/b requests from ASPs typically result with more than 100 records coming back. It takes a while to process them and all I need to show on the resulting webpage is 10 records. I still need all those 100-odd records to arrive on the web server, but I want to show only first 10 initially.
Instead of processing all 100 records before showing the first 10, is there any way to process the first 10, display them and keep receiving and processing the rest in the background?
The alternative is to retrieve 10 by 10 records, but that's very expensive on connection.
Thanks a bundle in advance.