I forgott to replay to the list. the database is close to the server. I did not find the way to copy the Database from Mac OS Frontbase to CentOS Frontbase or the other way. I tryed to recover me lokal Database with a Backup created with CentOS-Frontbase, but it fails.
So I think the best way for me will be the WRITE ALL export. I will take a look at this. Thanks Tobias 2014-05-06 7:58 GMT+02:00 Chuck Hill <[email protected]>: > Hi Tobias, > > I missed the "Frontbase in the cloud on centOS” before. Is the app > server not “close” to the database server? With latency like this, you are > going to face production issues, too. That would be my first concern. > > Some ideas to consider: > > - Import it locally, do a WRITE ALL export and import on the server > - Change to the binary UUID primary keys that are generated in the > application > - ERXLongPrimaryKeyFactory > > Chuck > > > On 2014-05-05, 10:28 PM, "Tobias Janz" wrote: > > Hi Chuck, > > thanks for your advice, but this approch i have allready tryed. I create > a new editing context for each 100. Also i've tryed multiple threads with > relevant success. > > When i do the import on my lokal database its much much faster. I think > it's because of the latency. Is there a way to savely create primary key > with multiple DB-connections in multiple Threads? And how do i get multiple > database connections? > > regards Tobias > > > 2014-05-06 1:32 GMT+02:00 Chuck Hill <[email protected]>: > >> 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 protected]) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [email protected]
