Changed to: Remote database performance

["Adam Lang" <aalang@xxxxxxxxxxxxxxxxxxxx>]

I have had issues with getting decent response speeds from Windows
applications I have written using ADO.  I know it isn't the AS/400 "per se",
because the same query will run fast as hell if run with wrkqry.  It seems
the problem is when trying to use the AS/400 as strictly a database and
having thick clients access it for data.

Are you saying that is the wrong approach?  I should have the database on
it, build a server app on the AS/400 that does the actual querying and write
an interface for my desktop client to talk to the server to handle data
transmission and not rely on IBMs OLE DB drivers?

This performance problem I have is also oriented with Crystal Reports too.

I have a Linux/PHP webscript that runs 2 left joins and uses DB2 Connect to
access the AS/400 and performance is a lot better.

Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
http://www.rutgersinsurance.com
----- Original Message -----
From: "Joe Pluta" <joepluta@PlutaBrothers.com>
To: <midrange-l@midrange.com>
Sent: Thursday, December 27, 2001 6:45 PM
Subject: RE: Trivia: Processor MHz


> > Does Oracle or Sql Server on a pc server run slower than DB2/400 ?   (
> > actual question )
>
> Yes.
>
>
> > ODBC or ADO from w2k to w2k is much faster than from w2k to
> > iSeries. ( based
> > on 2 examples from my limited experience )
>
> ODBC is not database access.  ODBC is remote SQL serving, and is a
horrible
> approach to just about any business architecture design.  If you want
> distributed processing, use a client/server design.
>
> As for a real comparison of database access, try performing 100,000,000
> inserts on a database with 15 logical views.  OS/400 won't even blink, but
> you'll crash most Windows databases and quite a few Unix databases as
well,
> and even if they survive, they certainly won't come close to the
performance
> of the AS/400.