If you're fetching several resultsets that contain a lot of common data, it can make sense to obtain a single resultset that has all the data that's required, store it in a temporary table, and then select from this temporary table as needed.
Read more »Using Temporary Tables to Speed Up MySQL
http://www.linuxplanet.com –
Created by polbaan 14 years 47 weeks ago – Made popular 14 years 47 weeks ago
Category: High End Tags:
Category: High End Tags:
- Login to post comments