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

[Ries van Twisk]

Martin Kutschker wrote:

>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?
>  
>
I think we should't rely on query cache at all and just think of a 'nice 
to have' thing.
Remember, SQL was not designed for speed. So we HAVE to make some data 
generation more intelegent.

Just my 2 cents.


Ries

>Masi
>_______________________________________________
>TYPO3-dev mailing list
>TYPO3-dev at lists.netfielders.de
>http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-dev
>  
>


-- 
Ries van Twisk
Freelance Typo3 Developer
=== Private:
email: ries at vantwisk.nl
web:   http://www.rvantwisk.nl/
skype: callto://r.vantwisk
=== Work:
email: ries at livetravelguides.com
web:   http://www.livetravelguides.com