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

[Dmitry Dulepov [typo3]]

Hi!

Martin Kutschker wrote:
> 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.

Query cache is a great thing... I was testing a query with multiple tables yesterday, that worked for 6 (six!) seconds ar the first run. Next run returned it after ~0.001 seconds because of query cache. I had to optimize that query a bit. It included time stamp as integer, so I could not really rely on cache ;)

-- 
Dmitry Dulepov
TYPO3 freelancer / TYPO3 core team member
Web: http://typo3bloke.net/
Skype: callto:liels_bugs