Re: I'm killing my database
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