Hi, just a quick question regarding performance and speed.
Q. Run a complicated query three times or create a TEMPORARY table and
access it as needed?
I have a page where it will be accessed 10,000+ a day.
In that page I have an SQL query where it involves 3 different tables
(approximate table sizes T1) 200,000 T2) 900,000 T3) 20 records)
I'll be running that query 3 times in that page...
One to retrieve the content and display it on the page.
Second to count the number of records (using COUNT(*) function)
And third to retrieve the content regions. (using DISTINCT function)
What would be the best way of doing...
Running the SQL query 3 times
Or
Create a temporary table and access it as many time as I need
Regards,