Re: Changed to: Remote database performance

I do not know the specifics of how DB2 Connect works, but this is what I
believe is accurate:
I make calls to it using the ODBC API in PHP, BUT when I compile ODBC, I
compile it with the DB2 Connect libraries.  As far as I know, the ODBC calls
are merely masked.  DB2 Connect is really a daemon that runs on the Linux
server, not a driver.  It communicates with the AS/400 via CLI (not sure if
that is different than what ODBC/OLE DB does on Windows).  Plus, DB2 Connect
is made for multi-user systems and not necessarily single user like ODBC.

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: Friday, December 28, 2001 12:12 PM
Subject: RE: Changed to: Remote database performance


> > 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.
>
> I'm not very familiar with DB2 Connect, but it sounds like a more
optimized
> ODBC.  I believe that the ODBC requests are actually forwarded to the
AS/400
> and handled there.  How this differs from the ADO approach is beyond my
> knowledge, except I know that DB2 Connect supports static SQL, which may
be
> why performance is better in your situation.  For me, comparing two SQL
> implementations is a little like deciding whether I'd rather have hives or
> chickenpox, but that's me.