[AccessD] VERY SLOW report

Hmmm, few things to look into.  First, make sure you have indexes on
everything that you can, where searches are being used.  (IE, if you are
pulling information from a list, and you only want records that have
'Something' in that field, then you should have an index on the field.).  I
would recommend no more then 3 or 4 indexes per table.....make them count.
 
That should speed things up quite a bit (indexes make a BIG difference).
Next, are you connecting to a Back End source?  If so, try running the
Backend locally, see if that helps.  If it does, there may be some network
issues involved.
 
Drew

-----Original Message-----
From: Barbara Ryan [mailto:BarbaraRyan at cox.net]
Sent: Thursday, May 29, 2003 2:17 PM
To: Access List
Subject: [AccessD] VERY SLOW report 


I have an Access 97 report that runs VERY slowly (I mean, like an hour or
more at times!).  Any suggestions you can offer would be greatly
appreciated.
 
The report header contains 5 subreports.  The detail section contains 7
subreports.  Each subreport contains,on average, appr. 3 detail lines and 1
total line. There are appr. 36 calculated fields per subreport.  There are
54 calculated fields in the detail section of the main report --- SO, 36 x 7
subreports + 54 = 306 calculated fields in each detail section of the
report.  Each detail section is printed on a new page.
 
The report is often more than 100 pages.  There are appr. 20 tables used in
the various queries of the main report and subreports.
 
The client needs all of this info in one report.  It is their Proposal that
they submit when bidding on a contract, containing all of the labor rates,
fringe benefits, overhead, profit, etc. for each union trade and level
(i.e., carpenter foreman, carpenter journeyman, etc.) for straight
time/overtime/double time for first shift, second shift, third shift.
 
Help!  
Barb Ryan

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030529/148eb85a/attachment-0001.html>