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.
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.