Slow report generation

[TrekBiker]

I've inherited a database that among other things generates invoices. The invoice reports take many seconds to appear and I'd like to reduce this time.

The report source is a query formed from a succession of other queries, and the report has one subreport.

The feeding tables contain about 5,500 customers, 70,000 orders, and 150,000 order items.

My first thought is to archive a lot of these records as they go back a long way. Are there other things to look for in speeding up the report generation?

 

[dhookom]

Do you have page numbering? If so, can you remove them?

I have created temporary tables on the fly and filled them with data for the reports when the record numbers are very high. The append or maketable queries typically run very fast.

Duane
Vevey, Switzerland
Hook'D on Access
MS Access MVP 2001-2016

 

[TrekBiker]

Hi Duane

The reports are very rarely more than a page long, and the slow response is even for these.

 

[dhookom]

I would make sure that all records used for sorting and grouping or link master child were indexed.

Duane
Vevey, Switzerland
Hook'D on Access
MS Access MVP 2001-2016

 

[TrekBiker]

Thanks, I'll give that a try.