Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Speeding up reports

Status
Not open for further replies.

bebbo

Programmer
Joined
Dec 5, 2000
Messages
621
Location
GB
I have a program which contains archive information in 4 tables. This information can go back some years. These tables are linked together via indexes, set relation, and filtering (mainly date ranges). Using these tables different reports are available. Problem I have they can take some time to run. I believe this to be mainly due to the amount of data stored and due to the fact that the reports are usually completed over the network on a slave machine. Is there some way I can spead these up??

I've never used SQL. This this used to speed things up??? Sorry for my ignorance.
 
By filtering, do you mean you are using: SET FILTER TO Expression ?

Filtering in this way is known to be slow. You can use indexes to filter instead.

Creating a temporary (SQL) cursor to show your data could be an option. If it is faster, I wouldn't know, you'll have to test that (depending on your machine, network speed etc.).
The advantage is that you can filter out data that is not necessary and you can store all info in one cursor, without having to set relations etc.

Good luck,

HTH,

Weedz (Wietze Veld)
My private project:CrownBase source code can be downloaded !!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top