|
We have been using Transformation server for about three years now and the performance increase was 10x to 90x depending upon the application. Our queries are web Active Server Pages and MS Access. We do have a low end AS/400 (620-2179), but that increase was with a moderately configured SQL Server box (1 ghz Xeon). We are ordering a new AS/400 810-2466 and a new SQL Server. I'll post performance comparisons when both new boxes are installed. I expect the differences to be less pronounced, but still significant. The nice thing about this setup is that you can optimize the SQL Server box for queries. It also provides a nice standby system (i.e. stock locations) if your AS/400 ever goes down. You can set up Transformation server to send data to multiple SQL Server boxes if your needs dictate. One thing to keep in mind is that Transformation server is going to want a unique key for each file. This is a real challenge for many of the JBA files. Biggest problems we have run into is INP95, PMP09 and CRP09. Dan Thomas Director of Information Technology MDI 4500 Progress Blvd Louisville, KY 40218 (502) 318-1208 This message is a privileged and confidential communication protected by the Electronic Communications Act and is intended for the designated recipients only. Duplication or distribution of this email beyond the intended recipients without prior written consent of the sender is strictly prohibited. -----Original Message----- From: Bill Pinnington [mailto:BPinnington@xxxxxxxxxxxxx] Sent: Monday, July 07, 2003 10:00 AM To: 'System 21 Users' Subject: RE: [SYSTEM21] JBA Reporting Joe, You can use a product called Transformation Server from Datamirror to transfer data from your AS/400 to your reporting database (e.g. SQL Server) in real time. That way you get much better reporting performance against real time data, AND free up your 400's CPU for more important stuff. Regards, Bill -----Original Message----- From: Joe Roesch [mailto:jroesch@xxxxxxxxxxxxxxx] Sent: 07 July 2003 14:18 To: 'System 21 Users' Subject: RE: [SYSTEM21] JBA Reporting This message has been successfully virus checked by the Centura Foods Mail system. The ODBC link (for Crystal) can become very slow depending upon the table size accessed from the AS400. Information warehoused in another database, such as SQL Server or Oracle for example, has exponentially faster access the larger the data becomes on the AS400. However, this is limited to data that is not constantly updated (i.e. pulled hourly or nightly) where real time is critical. -----Original Message----- From: Angus Appleby [mailto:aappleby@xxxxxxxxxxxxxxxxxx] Sent: Thursday, July 03, 2003 11:29 AM To: System 21 Users Subject: RE: [SYSTEM21] JBA Reporting I found the ODBC driver quite slow when trying to create Crystal Reports - how are you connecting to the AS/400? Angus "Trask, William" <WTrask@xxxxxxxxxxx> Sent by: system21-bounces@xxxxxxxxxxxx 03/07/2003 16:03 Please respond to System 21 Users To: "'System 21 Users'" <system21@xxxxxxxxxxxx> cc: Subject: RE: [SYSTEM21] JBA Reporting Crystal Reports is a terrific product. We use Version 8.5, but there is a newer one out now. We use it for System 21 and other AS/400 programs - even tying System 21 records with our HR program. Reports can be dynamic or static - we publish static reports to our Intranet site for users. It also has a built in SQL Wizard which comes in handy sometimes. ---------------------- WW (Bill) Trask Hensley & Company Phoenix, AZ -----Original Message----- From: Todd Grass [mailto:tgrass@xxxxxxxxxx] Sent: Thursday, July 03, 2003 5:50 AM To: system21@xxxxxxxxxxxx Subject: [SYSTEM21] JBA Reporting We are searching for a better report writing method than query. Has anyone used the Crystal product and how did it work for you? Todd Grass American National Rubber TGRASS@xxxxxxxxxx _______________________________________________ This is the System 21 Users (SYSTEM21) mailing list To post a message email: SYSTEM21@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/system21 or email: SYSTEM21-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/system21. _______________________________________________ This is the System 21 Users (SYSTEM21) mailing list To post a message email: SYSTEM21@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/system21 or email: SYSTEM21-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/system21. _______________________________________________ This is the System 21 Users (SYSTEM21) mailing list To post a message email: SYSTEM21@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/system21 or email: SYSTEM21-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/system21. _______________________________________________ This is the System 21 Users (SYSTEM21) mailing list To post a message email: SYSTEM21@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/system21 or email: SYSTEM21-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/system21. ________________________________________________________________________ This e-mail has been scanned for all viruses by Star Internet. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ________________________________________________________________________ ======================================================= This email, its content and any files transmitted with it are confidential and intended solely for the use of the individual(s) to whom it is addressed. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. This email, its contents and any files transmitted with it have been prepared using information believed by the author to be reliable and accurate, but Centura Foods Ltd. makes no warranty as to accuracy or completeness. In particular Centura Foods Ltd. does not accept responsibility for changes made to this email or related files after it was sent. Any opinions expressed in this email and any related documents are those of the author and do not necessarily reflect the opinions of Centura Foods Ltd. or its associated companies. If you have received this email in error please notify the Centura Foods IT Helpdesk by telephone on +44 (0) 1606 830 533. ======================================================= ________________________________________________________________________ This e-mail has been scanned for all viruses by Star Internet. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ________________________________________________________________________ _______________________________________________ This is the System 21 Users (SYSTEM21) mailing list To post a message email: SYSTEM21@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/system21 or email: SYSTEM21-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/system21.
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.