|
Does it need to be done with ODBC? This seems like a good socket app... On Tue, 2 Dec 2003 15:19:13 -0600, "Steve Landess" <sjl_123@xxxxxxxxxxx> said: > My client is using SeeBeyond EAI (Enterprise Application Integration) > software to move data between platforms, from a SQL server 2000 sales > front end to an iSeries with JDE for billing, then from the iSeries to an > Oracle manufacturing system on the back end. > > We ran a stress test a couple of weeks ago and found some fairly severe > performance problems when inserting data into the iSeries database files. > SeeBeyond uses the CAE ODBC provider to connect to the iSeries, and it > appears that it is quite the dog, performance-wise. > > Here is a sample of our results: > > File Time for Record > insert (seconds) Length (bytes) > > A 4 707 > B .2 69 > C 7 1370 > D 1 208 > > It appears that the average data transfer rate is around 200 > bytes/second. > > All told, it took around 30 minutes to load the data for ONE sales order > into the iSeries database files. This is *not* good. > > The QZDASOINIT jobs run in the QUSRWRK subsystem, which currently uses > only the *BASE memory pool. I'm not sure that creating a private memory > pool for this subsystem will help any...I think that the bottleneck is > the CAE ODBC driver. > > Any ideas on improving the performance of this application? > > TIA for your advice, > Steve Landess > _______________________________________________ > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing > list > To post a message email: MIDRANGE-L@xxxxxxxxxxxx > To subscribe, unsubscribe, or change list options, > visit: http://lists.midrange.com/mailman/listinfo/midrange-l > or email: MIDRANGE-L-request@xxxxxxxxxxxx > Before posting, please take a moment to review the archives > at http://archive.midrange.com/midrange-l. > -- michaelr_41@xxxxxxxxxxxxxx -- http://www.fastmail.fm - Same, same, but different?
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.