P
PW
I am writing an ASP application which sits on top of an Access database
which contains a table with over 100K records.
I need to display approx 10 records at a time. Therefore I dont want to
"select * from table" and then page, as the initial "select" statement will
be very slow to perform.
Is there such a thing as "SELECT NEXT 10 * FROM TABLE" or something similar,
where I can just retrieve the initial 10 records, and subsequently fetch the
next 10 when the user clicks a "next" button?
which contains a table with over 100K records.
I need to display approx 10 records at a time. Therefore I dont want to
"select * from table" and then page, as the initial "select" statement will
be very slow to perform.
Is there such a thing as "SELECT NEXT 10 * FROM TABLE" or something similar,
where I can just retrieve the initial 10 records, and subsequently fetch the
next 10 when the user clicks a "next" button?