|
Wish I could give a similar endorsement, but... We have a VB application that connects to either DB2 or a SQL Server database depending on the type of user (both connect using ODBC). Every performance comparison we run show exponential differences in SQL Servers favor. We are comparing on the desktop, from the time the request is made until the result is returned. The differences are especially apparent on the initial request - first time running the statement or stored procedure. Even after the AS/400 is 'primed', however, there is a consistent 1/10 to 1/2 second of 'overhead' in the AS/400 requests. Running debug on the AS/400 shows the database itself is competitive, but the ODBC layer seems to be much slower when compared to the SQL server connection. Has anybody found similar results? More important, has anybody found a solution to this? Thanks, JN -----Original Message----- From: Andrew Borts [mailto:Andrewb@SETACORPORATION.com] Sent: Friday, December 28, 2001 8:46 AM To: midrange-l@midrange.com Subject: Re: - the simple query on the 400 that was 5 minutes was 45 OK - I remember cheering loudly - jumping up & down, and I also remember similar performance when I was manipulating a 60,000 record file on a PC @ the time. DB2 on an AS/400 is the flat footest, most fantastic - quick as a bunny - faster then a speeding bullet Database in the world. Problem is, a green screen ain't going to show it off unless you're crunching reports @ Light speed. You need "Yahoo like" traffic to see the real lookup speed. A relational database on an AS/400 kicks the butt off of mainframes, etc.. Message: 3 From: "David Bulog" <d2ba@xtra.co.nz> To: <midrange-l@midrange.com> Subject: - the simple query on the 400 that was 5 minutes was 45 Date: Fri, 28 Dec 2001 11:17:17 +1300 Reply-To: midrange-l@midrange.com Andrew, Do you have any more detail?How was the Query done on the AS/400 and what was the backend db for the PC cheers Dave <. In Computerworld - I read of a company that had to switch back from PC Server to AS/400 - the simple query on the 400 that was 5 minutes was 45 minutes on a PC... for Database - the 400 is the fastest on the planet... Andrew Borts / Webmaster Seta Corporation 6400 East Rogers Circle Boca Raton, FL 33499 E-mail: Andrewb@setacorporation.com Corporate web site http://www.setacorporation.com E-Commerce web site http://www.palmbeachjewelry.com http://www.myfreeitems.com Voice: 561-994-2660 Ext. 2211 / Fax: 561-997-0774 _______________________________________________ This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@midrange.com To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l or email: MIDRANGE-L-request@midrange.com Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l.
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.