• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: @sum optimization?
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: @sum optimization?


  • Subject: Re: @sum optimization?
  • From: Florijan Stamenkovic <email@hidden>
  • Date: Mon, 28 Apr 2008 13:22:49 -0400

I thought that @count operates directly on the db, if the to-many is still faulted... Am I mistaken about that? I am pretty sure I've read it is optimized somehow, if not to do a count query on the db, then how? And, if @count does it, why not @sum too?

On Apr 28, 2008, at 11:37, Pierre Bernard wrote:

Once you are in the OO world, you stay there: an optimization would break if you were to have uncommited additions to "books"

How is this any different then doing a manual sum? Assuming that the relationship is a fault, and optimized, EOF performs this operation on the DB, you get the latest state saved to the DB. If it is not a fault, you do it in memory, and get the latest state of the context of the relationship's source. Either way, you get the latest of what the context can be aware of. If there are uncommitted additions to "books" in other contexts, you don't get those anyway, before they are committed, right? So, what is the difference? Except for firing a potentially large to-many fault unnecessarily...


Am I missing something?

F
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden


  • Follow-Ups:
    • Re: @sum optimization?
      • From: Alexander Spohr <email@hidden>
References: 
 >@sum optimization? (From: Florijan Stamenkovic <email@hidden>)

  • Prev by Date: Re: Best Server Environment for Large WebObjects Applications
  • Next by Date: Re: Forms changed to http with Eclipse/WOLips?
  • Previous by thread: Re: @sum optimization?
  • Next by thread: Re: @sum optimization?
  • Index(es):
    • Date
    • Thread