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.






As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 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.