How to speed up program processing

  • Thread starter Thread starter Tony Girgenti
  • Start date Start date
T

Tony Girgenti

I'm having a problem with an AccessXP program using externally linked tables
thru ODBC. The program works fine with a small amount of test data in the
tables(couple hundred records in each table). When i attempt to use it on
live client data, it runs for over 24 hours and never finishes. We have to
terminate it by using Task manager/applications(alt-ctrl-del). It uses 100%
of the resources, shows in task manager as not responding. The following
tables and their record counts are used.

Customers 27,069
Items 2,698
Order Headers 92,502
Order lines 159,366

I'm running it on a new DELL Dimension 2350, 2.0ghz, 256meg RAM, 18gig HDD

The program is pretty simple. It creates an export file and optional report
using:
DoCmd.OpenReport strcReportName, acViewPreview
DoCmd.TransferText acExportDelim, , strcQueryName, strFile

If any anybody has any ideas on how to speed this program up or how i can
track the progress of the query, i would greatly appreciate it.

Thanks,
Tony
 
Linked to what database using ODBC? How complicated is strcQueryName? Is
report strcReportName based on strcQueryName?

If the queries are somewhat complex, consider using Pass-through queries, so
that the process takes place on the server, not in your application.
 
Which line is blocking? The report or the export?
Is it the report/export that is blocking, or is it the query?
What happens when you try to open the query without using
the report/export?

(david)
 
Back
Top