[TYPO3-dev] Optimizing last 20 query
John Angel
johnange at gmail.com
Thu Mar 15 22:07:58 CET 2007
Hi Peter,
> As queries for latest records are pretty common it might be helpful to
> index crdate and tstamp by default.
EXPLAIN says:
- pages: using parent key, rows: 5000, extra info: Using where; Using
filesort
- tt_content: using parent key, extra info: Using where
The majority of records is coming from pages tables, so tt_content indexes
are not making much sense. Also, additional pages indexes are not doing any
good, it always uses parent key.
Am I missing something?
Regards,
John
More information about the TYPO3-dev
mailing list