Re: Lots of EOs slow down the performance
Re: Lots of EOs slow down the performance
- Subject: Re: Lots of EOs slow down the performance
- From: JR Ruggentaler <email@hidden>
- Date: Thu, 6 Nov 2008 16:13:11 -0600
| When loading lots of data the DMS engine bulk loading feature is usually the fastest.
MySQL Example command: LOAD DATA INFILE 'data.txt' INTO TABLE db2.my_table
Derby Example command: CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE(null, 'staff', 'data.txt', ';', '%', null,0)
Oracle and most RDBMS systems have similar functionality but I am not sure if this is applicable to your problem. It's just the fastest way I have found to load lots of data into a database.
An alternative might be to offload the loading work to an "Agent" (back end app that uses EOF or other technique). When the "Agent" completes the loading it could update a row in the database that the WO App could check to see that the data is loaded.
JR |
_______________________________________________
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