• 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: I'm killing my database
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: I'm killing my database


  • Subject: Re: I'm killing my database
  • From: Lachlan Deck <email@hidden>
  • Date: Wed, 25 Apr 2007 12:21:41 +1000

Hi Scott,

On 25/04/2007, at 8:55 AM, Scott Winn wrote:

I'm working on a flat file importer (groan). Creating EOs and writing to the database (Frontbase) seems to work fine. The objects I'm creating with the data have relationships like a tree structure with a single object (Certificate) at the top level followed by the next two tiers. There may be several hundred objects in the "tree", but 800 objects related to the top level Certificate would be enormous and extremely rare.

Sometimes my source data contains corrections. The most reliable way to handle them is to cascade delete the old objects and write new ones. There is nothing in my import correction data that tells me what has changed, so an edit seems pretty much out of the question. What I am finding is that EC.saveChanges after the delete tends to get slower the more of these I process. Eventually the database seems to hang-up; and by hang-up I mean, go to the DB management application and it says the database is stopped. I match certain data (dates, codes, etc) with the record I'm importing. If it matches I delete the one I have in the database before writing a new one. EC.deletedObjects just shows the one I am getting rid of.

Don't know what's happening with the database...

but as to the saveChanges getting slower, have you tried the following?
ec.setUndoManager( null );

with regards,
--

Lachlan Deck



_______________________________________________
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


References: 
 >I'm killing my database (From: Scott Winn <email@hidden>)

  • Prev by Date: Re: Fetch cancelled
  • Next by Date: Re: I'm killing my database
  • Previous by thread: I'm killing my database
  • Next by thread: Re: I'm killing my database
  • Index(es):
    • Date
    • Thread