[TYPO3-dev] Testing TYPO3 caching vs.[FE][pageCacheToExternalFiles]

[Martin Kutschker]

Dmitry Dulepov schrieb:
> Hi!
> 
> Martin Kutschker wrote:
> 
>>Go and find slow queries.
> 
> Indexed search, usually more than 5 secods to select from index_section
> and one another table.
> 
>>Then figure out how to improve them.
> 
> I actually gave up on this :(

Knowing a bit (bit not more) I can understand you.

> Indexed search sometimes issues queries with tons of page uids in IN
> clause. These also run extremely slow.

Oh those nice IN-lists to be found also elsewhere in TYPO3...

Perhaps it is faster to create a temp. table (TYPO3 type "temporary"!) with 
those ids and then do a JOIN instead on listing them in IN.

To speed up browsing within search results I have plans to dig up an old 
search-result caching scheme. No need to do the query again and again when 
browsing the result. I know... there is the Mysql query cache. But why rely 
on Mysql caching multiple queries when we can take some burden of the machine?

Masi