[TYPO3-dev] Optimizing last 20 query
Peter Russ
peter.russ at 4many.net
Thu Mar 15 23:01:31 CET 2007
John Angel schrieb:
> 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
>
Did you test it? Or is this just an academic answer?
Regs. Peter.
--
Fiat lux!
Docendo discimus.
_____________________________
4Many® Services
openBC: http://www.openbc.com/go/invuid/Peter_Russ
More information about the TYPO3-dev
mailing list