[TYPO3-dev] performace of cachingframework

[Dmitry Dulepov]

Hi!

Steffen Kamper wrote:
> absolute correct. That makes it so difficult to find the best indexes
> for TYPO3 tables.

There are too many different queries to optimize that. What we need is 
something like a "storage" object for each record type (like a "page 
storage"). That would return the record with the given query and cache it 
(at least by id) to avoid database queries to the same record from other 
parts of the core.

I thought of doing that on t3lib_db level but that is too low level point.

It would be a big architectural change if we do such layer but may be we 
should if we want to improve performance.

-- 
Dmitry Dulepov
TYPO3 core&security team member
E-mail: dmitry.dulepov at typo3.org
Web: http://dmitry-dulepov.com/