AndyHumpherson
Registered User.
- Local time
- Today, 11:49
- Joined
- Jun 25, 2012
- Messages
- 22
Hi All
I may be able to put a copy of my database up for review but thought i'd ask the question first.
I have a database that reports on management information regarding deliveries and collections for health trusts and local authorities. It is big current over half a million lines of data.
I have 7-10 sub reports and charts grouped under one main report that are produced monthly. I have some code in a module that exports the reports based on various criteria to break the information down.
Now these reports are taking ages. The main report takes easily an hour to run, while the other reports take 15 minutes to half an hour to run and export.
I've tried a few things:
- Indexing all my fields that I use for criteria.
- Merging some queries to avoid duplicate running.
- Only importing the data that I actually need.
Any suggestions on how to improve this?
I may be able to put a copy of my database up for review but thought i'd ask the question first.
I have a database that reports on management information regarding deliveries and collections for health trusts and local authorities. It is big current over half a million lines of data.
I have 7-10 sub reports and charts grouped under one main report that are produced monthly. I have some code in a module that exports the reports based on various criteria to break the information down.
Now these reports are taking ages. The main report takes easily an hour to run, while the other reports take 15 minutes to half an hour to run and export.
I've tried a few things:
- Indexing all my fields that I use for criteria.
- Merging some queries to avoid duplicate running.
- Only importing the data that I actually need.
Any suggestions on how to improve this?