• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: Lots of EOs slow down the performance
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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

References: 
 >Lots of EOs slow down the performance (From: "Yung-Luen Lan" <email@hidden>)
 >Re: Lots of EOs slow down the performance (From: Guido Neitzer <email@hidden>)
 >Re: Lots of EOs slow down the performance (From: "Yung-Luen Lan" <email@hidden>)
 >Re: Lots of EOs slow down the performance (From: Guido Neitzer <email@hidden>)
 >Re: Lots of EOs slow down the performance (From: "Yung-Luen Lan" <email@hidden>)
 >Re: Lots of EOs slow down the performance (From: Andrew Lindesay <email@hidden>)

  • Prev by Date: Re: Lots of EOs slow down the performance
  • Next by Date: Re: Caching CSS and .js files
  • Previous by thread: Re: Lots of EOs slow down the performance
  • Next by thread: Re: Lots of EOs slow down the performance
  • Index(es):
    • Date
    • Thread