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.
I've never used SQL. This this used to speed things up??? Sorry for my ignorance.