Re: [seam-dev] Website performance - help offer
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