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