Database Record Chunking Question


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Database Record Chunking Question

  1. #1
    Brian LaBrake Guest

    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.

    Brian



  2. #2
    John K. Guest

    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
    >
    >




Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center