[TYPO3-dev] Quick speed test mysql vs mysqli, for now a win for mysql

ries van Twisk typo3 at rvt.dds.nl
Tue Oct 9 14:09:32 CEST 2007


On Oct 9, 2007, at 6:16 AM, Martin Kutschker wrote:

> ries van Twisk schrieb:
>> Hey Guys,
>>
>> today I did a very quick speedtest for mysql native and mysqli with
>> prepared statements.
>>
>> I filled a simpel table with 1000 records and each records has one  
>> test
>> field with 1Kbye of random textual content.
>
> I think that the cached version is faster because a) the query plan  
> is not
> expensive for the simple query and b) the query cache is large  
> enough to
> hold all of those random queries.
>
> Masi



Excactly!

But this is what happens a lot in typo3... we do a lot of simple
queries to get result sets from the database.

I currently don't have a large enough installation to get the pages/ 
tt_content
tables from and do more or less better what typo3 does.

However this quick test does show that prepared doesn't have to be
faster, special for MySQL version below 5.1.7 ??? (forgot the
exact version already...

Ries










More information about the TYPO3-dev mailing list