[seam-dev] Website performance - help offer

Sebastian Hennebrueder usenet at laliluna.de
Wed Mar 12 20:57:14 EDT 2008

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


More information about the seam-dev mailing list