ODBC Performance with DB2/2 
Author Message
 ODBC Performance with DB2/2

Hi There,

I'm new to db2 and have a tricky job to do: performance tuning of an Delphi
Application running against DB2/2.
To become familiar with this architecture I wrote a little test app (using
TQuery Objects) that performs large numbers of SQL Statements and measures
the time used.

The results were quite disappointing:
1000 Inserts took about 70 Second with db2,
about 30 Seconds with Interbase,
and about 4 Seconds with MS SQL Server.

The Results for Updates, Selects and Delete behaved with almost the same
ratio. (I was using a Win3.1 and A WinNT Version of my app which produced
almost the same values).

Everyone I ask from my Companies DB section tells me "use embedded SQL and
everything will be fine". But of course Delphi (and equally VisualBasic or
PowerBuilder) are not designed for embedded SQL.
Is ODBC and dynamic SQL really such an inperformant thing to do with DB2?
Are there any means to improve performance for ODBC Apps using DB2?

Some things that I know from other RDBMS don't seem to work with DB2 (or
with Delphi -> ODBC -> DB2 respectively):
- Improving speed with BEGIN TRANSACTION ... COMMIT TRANSACTION for mass
updates and inserts.
- Using "?" Params in the Statements resulted in ODBC Driver errors.
- Dynamic creation of Stored Procedures at run time not supported ?

Thanks for answering,
Thomas Mahler



Wed, 18 Jun 1902 08:00:00 GMT
 ODBC Performance with DB2/2

Use ODBCExpress. Get trail software at www.odbcexpress.com



Quote:
> Hi There,

> I'm new to db2 and have a tricky job to do: performance tuning of an
Delphi
> Application running against DB2/2.
> To become familiar with this architecture I wrote a little test app
(using
> TQuery Objects) that performs large numbers of SQL Statements and
measures
> the time used.

> The results were quite disappointing:
> 1000 Inserts took about 70 Second with db2,
> about 30 Seconds with Interbase,
> and about 4 Seconds with MS SQL Server.

> The Results for Updates, Selects and Delete behaved with almost the same
> ratio. (I was using a Win3.1 and A WinNT Version of my app which produced
> almost the same values).

> Everyone I ask from my Companies DB section tells me "use embedded SQL
and
> everything will be fine". But of course Delphi (and equally VisualBasic
or
> PowerBuilder) are not designed for embedded SQL.
> Is ODBC and dynamic SQL really such an inperformant thing to do with DB2?
> Are there any means to improve performance for ODBC Apps using DB2?

> Some things that I know from other RDBMS don't seem to work with DB2 (or
> with Delphi -> ODBC -> DB2 respectively):
> - Improving speed with BEGIN TRANSACTION ... COMMIT TRANSACTION for mass
> updates and inserts.
> - Using "?" Params in the Statements resulted in ODBC Driver errors.
> - Dynamic creation of Stored Procedures at run time not supported ?

> Thanks for answering,
> Thomas Mahler



Wed, 18 Jun 1902 08:00:00 GMT
 ODBC Performance with DB2/2

Quote:

> Hi There,

> I'm new to db2 and have a tricky job to do: performance tuning of an Delphi
> Application running against DB2/2.
> Are there any means to improve performance for ODBC Apps using DB2?

Use Intersolv's drivers.  They're much faster than the ones IBM supplies.  In
fact, they're much faster than the native interface IBM supplies; I don't know
how they do that, but they do.


Wed, 18 Jun 1902 08:00:00 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. ODBC performance on db2/400

2. Hit ODBC DB2 driver versus IBM ODBC driver for DB2

3. ODBC connection to DB2 on AS/400 and performance with protocols / port / connection

4. DB2 Connect vs. ODBC performance

5. DB2 Newbie needs help with DB2 5.2 ODBC: can browse schema, but get no data

6. DTS & DB2 ODBC Driver Using DB2 Connect

7. Distributed DB2 - Oracle/Oracle - Oracle/DB2 - DB2/DB2

8. Differences between SQL on DB2-MVS and DB2-OS/2 or DB2-NT

9. DRDA (Informix <-> DB2 mainframe) Performance Q.

10. PHP and DB2 (performance)

11. MD-Hyattsville-260455--DBA Skills-Performance Tuning-Client/Server-DB2-DBMS-ORAC


 
Powered by phpBB® Forum Software