Re: managing helma collections

<[email protected]> Tue, 7 Aug 2007 14:10:11 +0200
Newsgroups gmane.comp.java.helma.general
Message-ID <[email protected]>
> I didn't get a chance to read Tobi's actual bug report before writing
> my email and so I realise now I misunderstood the point of his email
> being about performance/scalibility with sorting large collections
> (ie. large   
> mailbox) rather then about the functionality of getOrderedView().

i think it's about all these issues: performance, scalability, functionality - shortly: a neat and nifty way to realize pageable and sortable collections of hopobjects.

> And from a scalability point of view, I think it does make sense to
> order a collection (mapped to an sql db) using sql rather then
> in-memory sorting since otherwise for very large collections you
> won't be able to sort collection that don't fit into the memory cache
> (or have I misunderstood that?).

afaik we could hardly beat the sql order statement with a java or javascript sorting method, at least when it comes to really large collections.

ciao,
tobi