Re: Prompting large number of records

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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

  • Re: I want my WEB page to access my SQL, and I run into several problems
    ... layout for displaying my sql database. ... I assume that the database you are retrieving data from is on ... activex components in IE for data access is tricky to make safe. ...
    (microsoft.public.data.odbc)
  • Re: Problem with VBA created subform in Access 2007
    ... machine not be seeing the delay in the DB. ... User-authorization for exclusive database access. ... default open mode set to exclusive access, ...
    (microsoft.public.access.modulesdaovba)
  • Re: How do I limit Outline Number to exclude level 1?
    ... Thanks, Steve. ... > table (and most of the time, frankly, I'd agree with him that displaying ... > defining a custom WBS code. ... A database view of a data set is usually ...
    (microsoft.public.project)
  • Re: DDE Connection
    ... the database is displaying something other than the default text in Access's title bar ... open the database if it is not already open. ... Access database works fine, where I'm able to open the query through the "open source" within the mail merge function of Word, but When I try to do the same exact steps with our Production Access database I get the following error. ... I'm running a Dell optiplex 745 machine with Windows XP sp2 and using Microsoft Word 2000 sp3 and trying to connect to a query in Microsoft Access ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Problem with VBA created subform in Access 2007
    ... that is showing the delay problem i turned all of the autocorrect options to ... but I still see the delay. ... made in the database stored on our server) I tried to connect two machines to ... default open mode set to exclusive access, ...
    (microsoft.public.access.modulesdaovba)