Re: Paging Data

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Jerry Pisk (jerryiii_at_hotmail.com)
Date: 05/16/04

  • Next message: qiangzi123: "5800541" 
    Date: Sat, 15 May 2004 21:06:28 -0700

    There are actually number of ways to handle this. One is to handle paging in
    your stored procedure (which is, at least imho, the preffered way, using the
    least resources). Another (one probably used in what you're describing) is a
    server side cursor, so the client only receives data when it moves to the
    next record, as oposed to having to load all data first.

    Jerry

    "Jeff Haumesser" <haumesser@karpel.com> wrote in message
    news:uKi69IpOEHA.3744@TK2MSFTNGP11.phx.gbl...
    > Good Morning:
    >
    > Oracle has a feature on a form that allows the user to Page through
    > large Recordsets at certain number of records at a time in a list or grid.
    > For instance, when the user wants to view ALL the records of a table or
    > view, the first chunk is Immediately displayed. As the user scrolls down
    or
    > pages down, the next chunks are displayed accordingly. Therefore, the
    > records are displayed almost instantaneasly, but only chunks at a time.
    It
    > doesn't have to wait for ALL the records to load into memory before
    > displaying them.
    >
    > I would like to do essentilaly the same in VB .NET. I have a listbox
    or
    > datagrid. The user, at times, would like to browse all the records of a
    > table or query that will ultimately result in 70,000+ records. However,
    the
    > time to load these records is horrendous due to a narrow bandwidth
    > connection of some locations.
    > I am currently using a Stored Procedure to load these records into a
    > Dataset then setting the List Datasource to that Dataset table.
    >
    > Does anyone have any ideas that would work along these lines?
    >
    > Thankyou in advance,
    >
    > Jeff
    >
    >

  • Next message: qiangzi123: "5800541"

    Relevant Pages

    • Re: Paging Data
      ... Does DotNet support Server Side cursors, and in what way would paging be ... > your stored procedure (which is, at least imho, the preffered way, using ... as oposed to having to load all data first. ... >> displaying them. ...
      (microsoft.public.dotnet.framework)
    • Paging Data
      ... large Recordsets at certain number of records at a time in a list or grid. ... but only chunks at a time. ... doesn't have to wait for ALL the records to load into memory before ... displaying them. ...
      (microsoft.public.dotnet.framework.windowsforms.controls)
    • Paging Data
      ... large Recordsets at certain number of records at a time in a list or grid. ... but only chunks at a time. ... doesn't have to wait for ALL the records to load into memory before ... displaying them. ...
      (microsoft.public.dotnet.framework)
    • RE: ListView, unstable image size
      ... "Dud Vickers" wrote: ... The tile size is 201,124 and the image size which was initially 43,124 is ... I can load images to the ImageList and then load this to the ListView, ... As well as loading the images I am also loading and displaying the image ...
      (microsoft.public.dotnet.framework.windowsforms.controls)
    • Re: Check/Unchek in PopUp Menu -- Tick mark is not toggleing
      ... > I am displaying a Pop Up menu on right click of List Control's ... > This popup menu is having Check/Tick marks. ... you load the menu again and display it. ... modifying it in memory, ...
      (microsoft.public.vc.mfc)