Thanks for imformative link.
I have just started Cayenne and trying to get used to it. In the same set of exercise, I was trying to pull a list of Subscriptions (paginated) sorted by magzine name. I did this, wondering if this is the most correct way to do it. (refer data model here http://i30.tinypic.com/jaz4wm.jpg ) DataContext ctx = DataContext.createDataContext(); Readers r = (Readers)DataObjectUtils.objectForPK(ctx, Readers.class, 200); Expression e = Expression.fromString("reader=$reader"); Map param = new HashMap(1); param.put("reader",r); SelectQuery q = new SelectQuery(Subscriptions.class,e.expWithParameters(param)); Ordering o = new Ordering(Subscriptions.MAGZINE_PROPERTY+"."+Magzines.M_NAME_PROPERTY, true); q.addOrdering(o); List<Subscriptions> subs = ctx.performQuery(q); - Nishant --- On Wed, 16/9/09, Aristedes Maniatis <a...@maniatis.org> wrote: From: Aristedes Maniatis <a...@maniatis.org> Subject: Re: Sorting and Pagination in Many-to-Many relationship To: user@cayenne.apache.org Date: Wednesday, 16 September, 2009, 7:22 AM On 16/09/09 6:22 AM, Nishant Neeraj wrote: > A question regarding caching. When we use SQLTemplate or Expression, does the > objects gets cached? I mean, these are very frequent used piece of code.... > as soon as user logs in we will show his list of Magazines... if the object > is not cached, we may have sluggish performance under load. For improved caching you definitely want to be using Cayenne 3. And the answer is that Cayenne does a very good job of caching, but you'll want to read the documentation carefully to understand what is going on. http://cayenne.apache.org/doc/caching-and-fresh-data.html Ari Maniatis -- --------------------------> Aristedes Maniatis GPG fingerprint CBFB 84B4 738D 4E87 5E5C 5EFA EF6A 7D2E 3E49 102A Now, send attachments up to 25MB with Yahoo! India Mail. Learn how. http://in.overview.mail.yahoo.com/photos
