[TYPO3-dev] Typo3 Performance

[Dmitry Dulepov]

R. van Twisk wrote:
> For mysql databases I am not sure how much time it will really save,
> since mysql has it's own query cache already. This is the same for other
> databases of course which uses other methods to cache results.

You do not count that you have to:
- call mysql_query
- it goes through socket
- mysql searches for query in cache
- result goes back through socket

> I have done some limited testing using adodb, DBAL
> and using CacheExecute and couldn't find a big improvement yet,
> at least not to justify the investigation time...

How much load did you have?

> I think we can get more speed out of setting indexes correctly, we might 
> consider
> a storing all queries in a database and the time it took to execute the 
> query
> or  filesystem (option can be turned off or on) and then based on the 
> acquired data
> we can create some statistics . Based on that it might shed some light
> on where to place indexes.

One does not exclude the other.

-- 
Dmitry Dulepov

Web: http://typo3bloke.net/
Skype: callto:liels_bugs

"It is our choices, that show what we truly are,
far more than our abilities." (A.P.W.B.D.)