Re: difficult object relational mapping

"Breton Slivka" <[email protected]> Thu, 6 Mar 2008 07:33:49 +1100
Newsgroups gmane.comp.java.helma.general
Message-ID <[email protected]>
A simpler way you might do it is to use helma.Database to perform your
ordered query, to get an array of object ID's. Then simply loop
through those id's with a collection.get(id[i]) call.  In a language
like PHP this would be a major performance mistake since it may
perform a new query for each and every get call. BUT because of
helma's object caching this actually works really fast, with very few
calls to the DB.