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 protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to [EMAIL PROTECTED]
