[seam-dev] Website performance - help offer

[Sebastian Hennebrueder]

Christian Bauer schrieb:
>
> On Mar 12, 2008, at 22:45 , Sebastian Hennebrueder wrote:
>
>> I had a first look at the wiki and resulting queries. Is it possible 
>> that you are using MySQL for your forum?
>>
>> The queries for the forum results in subqueries -> ForumQuery class.
>
> Yes, we use MySQL and yes, all the forum queries that used expensive 
> subqueries have meanwhile been optimized to use joins instead. Check 
> subversion trunk.
Alternative idea: use page fragment cache with a cache configuration 
allowing to overflow to the file system. This would limit memory 
consumption as well.

Best Regards

Sebastian