tree view causes lot of load on server

[capella]

I recently changed my view to tree view and observed that it is causing lot of load. can you comment on this?

Is there a way i can tune this better? Also have you thought about implementing a file cache or memcache where all the old comments are kept and database is queried only for new comments. This will improve in server load.

Also have you thought about pagination for tree view? I know in past you were asking for suggestions on this.
Here is my suggestion, although i am not sure if this is the best way of doing it, but here it is.

1. Query only comments which are parent comment and not a reply of any other comment.
2. Now do pagination of these comments as you would do in flat layout.
3. Now query for child comments and child comment either go to main page or sub pages based on where is the parent.

thanks

[smart]

I know that re-building tree every page load isn't good solution but at this time I don't see more better solution. In tree view mode comment could be inserted into any level of tree. So we couldn't place any part of tree into the cache. For server's there is no difference if it is query full tree or only last comments. It is quite fast. We lose time when we building object model of the tree and rendering the html.

In nearest future (but not in upcoming version) I'm going to add some kind of pagination. But not same as for flat list. I'm going to implement dynamic tree load (on user's demand). And separate first-level comments into chunks. Something like we could see on YouTube or AppStore - user would see 20 first-level comments and button like 'Next 20'. After pressing this button - next 20 comments (also first level) would be loaded and etc.

As you know development of the JComments never stops and with every version it getting more flexible, more stable, more fast and robust.  I'll do my best to solve any performance issues you have reported here. May be not fast as I want but I'll do it (I'm now hard at work on Joomla 1.6 compatibility). Stay tuned!