Re: Prompting large number of records

Tech-Archive recommends: Fix windows errors by optimizing your registry

Dear All,

Thanks for input. I do have the facility to enter a criteria, e.g. first
name or last name, and this does speed up data retrieval however customer is
adamant that they want to pull all 45000 in and scroll through.

I will view paging url to see if this will help.

Thanks all once again, i'll let you know how I get on.

Regards,
Martin


"Veign" wrote:

> Oops. I see you posted that you are using SQL Server 2000. Then look at
> the last option about paging through a stored procedure..
>
> --
> Chris Hanscom - Microsoft MVP (VB)
> Veign's Resource Center
> http://www.veign.com/vrc_main.asp
> --
>
>
> "Veign" <NOSPAMinveign@xxxxxxxxx> wrote in message
> news:%23cv8HLRmFHA.2060@xxxxxxxxxxxxxxxxxxxxxxx
> > Where is the database? What is the database? How are you displaying them?
> > Is the delay in updating the display (common place where delays occur)...
> >
> > - Rethink why 45K records are required - meaning does then end user
> actually
> > look through 45K records? (seems like they wouldn't since that is alot of
> > data to scroll through).
> >
> > - Provide better filtering to only pull down the exact records the user
> > needs to see.
> >
> > - Page the results and make it more manageable
> >
> > Recordset::PageCount
> > http://www.devguru.com/Technologies/ado/quickref/recordset_pagecount.html
> >
> > Recordset::PageSize
> > http://www.devguru.com/Technologies/ado/quickref/recordset_pagesize.html
> >
> > - Use a stored procedure to only pull down a recordset containing a page
> of
> > data so 45K records are not traveling across the wire.
> >
> > Paging through Records using a Stored Procedure:
> > http://www.aspfaqs.com/webtech/062899-1.shtml
> >
> >
> > --
> > Chris Hanscom - Microsoft MVP (VB)
> > Veign's Resource Center
> > http://www.veign.com/vrc_main.asp
> > --
> >
> >
> > "Martin" <Martin@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> > news:9F9FB683-55C5-4BB0-8204-0CE7D969B46A@xxxxxxxxxxxxxxxx
> > > Please help,
> > >
> > > I require to prompt on a customer master file of 45,000 records. When I
> > > load all these into my recordset it takes a long time (20 - 30secs).
> This
> > is
> > > unacceptable for my system. Can anyone show me some code that will
> allow
> > > this process to be a lot faster. e.g. can I load up a smaller amount of
> > > records at a time, and load in more as the user scrolls down.
> > >
> > > I am using VB6.0 and SQL Server 2000.
> > >
> > > Thanks for any help,
> > > Martin
> > >
> >
> >
>
>
>
.

Relevant Pages

  • How to you page and sort large dataset result in datagrid?
    ... Is there a good way to page/sort VERY large Result set in datagrid ... " Here's a stored procedure that I use for sorting and paging large ... or even thousands, of records, but working with larger recordsets with ...
    (microsoft.public.dotnet.framework.adonet)
  • paging and sorting
    ... The default paging of datagrid is somehow use too much resource, ... using Stored procedure for the paging. ... @PageSize int ... DECLARE @StartId int ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Stored procedure returns two result sets
    ... 'Get the values required for drawing the paging table ... intTotalPages = rsItems.Fields.Value ... The DataSource control ... If your stored procedure has two result sets, then you can make use of the ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: Lazy Loading Grid Object
    ... Yeah, I realize that I will be doing a "paging" type functionality, but make ... to an xml file and then running the grid from the local xml. ... row count and use to set the size, then when the user clicks on the scroll ... > as such you are going to have to load the whole lot or load it in sections ...
    (microsoft.public.dotnet.framework.aspnet)
  • Default Paging
    ... search the SQL Database for specific records. ... uses a SQL Stored Procedure with variables that the user ... and an event handler handles the paging. ... Sub Page_Load ...
    (microsoft.public.dotnet.framework.aspnet.datagridcontrol)