Using temporary table to increase MySQL query performance

Published on July 3, 2010 by Saeid Zebardast

Sometimes you need to get reports or something like, that runs a complex query which includes `JOIN`,  `GROUP BY`, `HAVING` and etc. The time of running is depends on amount of records and complexity. To run queries faster we can use temporary tables. How Temporary table helps us It is faster to get data from [...]

Tags: ,
Posted in MySQL

Categories

Archives