If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Database Record Chunking Question

I am trying to solve a problem involving retrieving a limited number of records
at a time from a database. My problem is I need to load a grid and have
to plan for low bandwidth connection to my middle tier. The system is a
physical three-tier system where the connection from the client to the app
server could be as slow as 128K. The record set that fills the grid could
possibly have several thousand records. Returning the whole recordset to
the client will cause a large delay. To prevent this, I want to retrieve
only a few records at a time (lets say 20) and get new records as the grid
needs them, i.e., as the user scrolls down. The App Server will query records
from the database and pass them back to the client in the form of a disconnected
recordset. The App Server cannot have state, so no persistent recordsets,
connections, etc.

So the question is, how do I get the first 20 records from a query, then
the next 20, etc., without creating a stateful connection to the database?
Thanks in advance for your help.

Re: Database Record Chunking Question

This question might be better answered in one
of the VB.Database groups.

"Brian LaBrake" <blabrake@iasystems.com> wrote in message
news:38d7aedc$1@news.devx.com...
>
> I am trying to solve a problem involving retrieving a limited number of
records
> at a time from a database. My problem is I need to load a grid and have
> to plan for low bandwidth connection to my middle tier. The system is a
> physical three-tier system where the connection from the client to the app
> server could be as slow as 128K. The record set that fills the grid could
> possibly have several thousand records. Returning the whole recordset to
> the client will cause a large delay. To prevent this, I want to retrieve
> only a few records at a time (lets say 20) and get new records as the grid
> needs them, i.e., as the user scrolls down. The App Server will query
records
> from the database and pass them back to the client in the form of a
disconnected
> recordset. The App Server cannot have state, so no persistent recordsets,
> connections, etc.
>
> So the question is, how do I get the first 20 records from a query, then
> the next 20, etc., without creating a stateful connection to the database?
> Thanks in advance for your help.
>
> Brian
>
>