Re: - the simple query on the 400: SUBJECT CHANGE to SQL Server faster -- MIDRANGE-L

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.