• 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: Delete a table content
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Delete a table content


  • Subject: Re: Delete a table content
  • From: David Teran <email@hidden>
  • Date: Tue, 6 Sep 2005 13:38:05 +0200


Am 05.09.2005 um 17:48 schrieb Fabrice Pipart:

I think you are absolutely right.
I gave up the idea to change the rows with raw SQL. Loosing the sync was too bad for the rest of the application and it did not make sense to have to refetch all the objects !



Sorry, but this is just a short term solution. If you want to do it right, you must -always- keep in mind that the database is out of sync. For example because you use multiple instances, the database is used by other systems and such cases. IMHO its just to naiv thinking that there is only one WO instance and only one system accessing the database so best is: always keep in mind that EOF caches Database information and always check if you need 'fresh' data for a certain action. I think the biggest problem for users is the fact that EOF caches and that they have absolutely no idea how to deal with that fact. Ignoring it just because one uses only a single instance means a lot of refactoring when you need to add just one additional instance or even just one additional EOF stack in the same instance. So its important to know the basics about data freshness and such things.


I know others have different opinion about that but all i can say to them is ' go back in sandbox and pray you never need multiple EOF stacks or multiple instances or multiple applications using on single database' because the reality is they will need the one or the other sooner or later ;-)

There is a neat demo app called 'freshness explorer' or something like this on connect.apple.com for download. It was published after WWDC 2004 and is a good starter to understand the caching stuff from EOF.


cheers, david _______________________________________________ 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:
    • AW: Delete a table content
      • From: Helge Staedtler <email@hidden>
    • Re: Delete a table content
      • From: Fabrice Pipart <email@hidden>
References: 
 >Re: Delete a table content (From: Fabrice Pipart <email@hidden>)
 >Re: Delete a table content (From: Ken Anderson <email@hidden>)
 >Re: Delete a table content (From: Fabrice Pipart <email@hidden>)

  • Prev by Date: Re: Unable to find a class in WOLips
  • Next by Date: Re: PDF IE & filedownload
  • Previous by thread: Re: [SPAM] Re: Delete a table content
  • Next by thread: Re: Delete a table content
  • Index(es):
    • Date
    • Thread