[thelist] ASP: Jump to specific record in recordset

Ken Kogler gsls at kenkogler.com
Wed Mar 17 08:09:13 CST 2004

> Why aren't you using SQL to just bring back the record you want,
> rather than having the database stream back 94 unnecessary records?

My db server is slow; my webserver is fast.

I'm never bringing back more than 20 records.

This is a three-table join which brings back <20 rows and 10 columns in
one lump sum. It's scope is already tightly defined and limited quite a
bit in the SQL, and the only other way to accomplish exactly what I'm
after here is to use multiple queries. 

I'd rather not call 2 or 3 separate queries per page when I can bring
back one and filter it on the webserver before sending it to the client.


More information about the thelist mailing list