Re: PrimaryKey generation takes a lot of time
Re: PrimaryKey generation takes a lot of time
- Subject: Re: PrimaryKey generation takes a lot of time
- From: Chuck Hill <email@hidden>
- Date: Mon, 05 May 2014 23:32:02 +0000
- Thread-topic: PrimaryKey generation takes a lot of time
|
Are you creating the objects and saving them all at once? If so, that is your problem. Save them in batches of 500 or 1000 and it will go much quicker. You might want to try making a new editing context for each batch.
Chuck
On 2014-05-05, 4:29 PM, "Tobias Janz" wrote:
Hi all,
i need to import a csv-file with about 58.000 Lines und 60 Columns. I have 8 Entitys where the values will be stored. The conversion of a line to entitys takes almost no time. But the full prozess, from conversion until saveChanges is done, takes several hours
(5-6h). After profiling it points me to the generating of primary keys. This part uses half of the time.
I need to do the import several times.
Do you see a way to improve the speed?
I'm using WebObject 5.4.3 (with Wonder). My Development is on Mac. Database is a Frontbase in the cloud on centOS.
Thanks for any advice.
Tobias
|
_______________________________________________
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