[TYPO3-dev] rfc: minor db change for TS templates
R. van Twisk
typo3 at rvt.dds.nl
Thu Oct 5 13:18:32 CEST 2006
Dmitry Dulepov wrote:
> R. van Twisk wrote:
>> So if Mysql is smart (sometimes it really isn't smart) then it would
>> load the complete table
>> in memory and basically eliminating the index at all. This will save
>> HD's seeks.
>> I just hope Mysql is smart :)
> I hope too but if it has to load too many tables to memory it would not
> be good. It seems for me that mysql does this only if it has enough memory.
I think that most people TS will be fairly small... and just a couple of
rows in the table.
Optimizing on sys_template is just almost pointless I would guess.
Like you said, it is different on tables with many records. It's just
what the optimizer
Ries van Twisk
Freelance Typo3 Developer
email: ries at vantwisk.nl
email: ries at livetravelguides.com
More information about the TYPO3-dev