[TYPO3-dev] Optimizing last 20 query

[Staffan Ericsson]

John Angel skrev:
> Hi Staffan,
> 
> It makes things even worse. Now we have "Using temporary":

But are that a temporary table in memory or on disk? If in memory and
the orginal source tables are very large it can become a preformance
boost, especially if you want to make the query several times during the
same session.

> 
> EXPLAIN SELECT SQL_NO_CACHE * FROM (
> SELECT crdate, title, uid
> FROM pages
> WHERE pid
> IN ( 1000 ) AND deleted =0
> AND t3ver_state !=1
> AND hidden =0
> AND nav_hide =0
> ) AS cur_pages, (
> SELECT bodytext, pid
> FROM tt_content
> WHERE sys_language_uid =0
> AND deleted =0
> AND t3ver_state !=1
> AND hidden =0
> ) AS cur_content
> WHERE cur_pages.uid = cur_content.pid
> ORDER BY cur_pages.crdate DESC LIMIT 0 , 20
> 
> Regards,
> John
>