cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mark Stobbe <markstobb...@gmail.com>
Subject Re: Updating totals in a multi-user environment
Date Thu, 30 Oct 2014 16:09:03 GMT
Hi Michael,

I would like to display the count in a table for a whole bunch of orders.
In theory I could use a "group by"-query to get the numbers I need and with
proper configured indices this should be fairly quick, I guess.

Is there a more transparent way of doing things, e.g. using lifecycle
listeners, datachannel filters and such?

Mark

On Thu, Oct 30, 2014 at 4:15 PM, Michael Gentry <mgentry@masslight.net>
wrote:

> Hi Mark,
>
> Is there a performance reason why you don't just do a count on the
> packages that match the order?
>
> mrg
>
>
> On Thu, Oct 30, 2014 at 11:00 AM, Mark Stobbe <markstobbe85@gmail.com>
> wrote:
> > Hi all,
> >
> > I was wondering what is the best way to update totals in a multi-user
> > environment. For example, let's say we have an Order which can have one
> or
> > more Packages associated and we want to maintain a total package count on
> > the Order entity. How would you update this value when the user has the
> > option to add/remove packages.
> >
> > So the entities looks like:
> >
> > *Order*
> > --------
> > id : bigint
> > orderNumber : varchar
> > nrOfPackages : int
> >
> > *Package*
> > ------------
> > id : bigint
> > packageNumber : varchar
> > *fk_order : bigint*
> >
> > What do you guys use to solve this?
> > Mark
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message