Anakardian
Registered User.
- Local time
- Today, 04:07
- Joined
- Mar 14, 2010
- Messages
- 173
After getting everything to work in the first place I am now looking at improving the speed of my queries since it takes 5 to 10 seconds to make the final result.
As it is today, I have 16 queries that collect and make calculations from a variety of tables for different subjects such as budget and inspections.
Most of the queries are summed up by a single query before it is put into a temporary table.
I am wondering if it would improve the speed if I put the result of each query directly into the temporary table instead of having a query collect it all and then placing it into the temporary table?
As it is today, I have 16 queries that collect and make calculations from a variety of tables for different subjects such as budget and inspections.
Most of the queries are summed up by a single query before it is put into a temporary table.
I am wondering if it would improve the speed if I put the result of each query directly into the temporary table instead of having a query collect it all and then placing it into the temporary table?