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 –
-->
Categories
From the staff of FSDaily: Comedians in Perth, Magicians in Perth, Bands in Perth
Popular this week
- 57Running ownCloud3 On Nginx (LEMP) On Debian Squeeze/Ubuntu 11.10
- 39FSF Announces JavaScript License Web Label
- 31How to make DuckDuckGo the default search engine in Chromium
- 22Lenovo ordered to pay €1920 for making French laptop buyer pay for Windows too
- 21Announcing my third e-book "Perl One-Liners Explained"
