[TYPO3-dev] Optimizing last 20 query

[John Angel]

> if so... is it currently slow on your server??

Yes, very slow with 5000 articles.


> You could change the pages.pid IN (1000) to = pages.pid = 1000
> and you could put a appropriate index.

I've used EXPLAIN, but didn't find any ideas for indices.


> I am not sure what SQL_NO_CACHE does, but it seems like non ANSI SQL?

It's just to avoid caching, usable for optimizing SQL statements.

> The above query will find all tt_content record directly below page 1000,
> are you looking for a query that can also find all tt_content records on
> sub-pages below page 1000 aswell??

No, it will not find content under page 1000, but under subpages of 1000.