[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:
> Hi!
> 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
would decide.


Ries van Twisk
Freelance Typo3 Developer
=== Private:
email: ries at vantwisk.nl
web:   http://www.rvantwisk.nl/freelance-typo3.html
skype: callto://r.vantwisk
=== Work:
email: ries at livetravelguides.com
web:   http://www.livetravelguides.com

More information about the TYPO3-dev mailing list