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: <email@example.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.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.