performance tips guide for using VB with DB2

[tbt102]

Hi All,

I'm looking to improve performance in my VB application where the backend DB is DB2.

Is there a performance tips guide for using VB with DB2?

The following is an example of what I'm looking for from the DB2 guide:

While ADO (and other VB object libraries) make database manipulation easy for the programmer, using these shortcuts can kill performance with SQL Server. As a rule of thumb, VB/SQL Server developers encapsulate their DML (Data Manipulation Language) in stored procedures and run them from your VB application. This bypasses the object library reducing overhead.


Environment
===========
Windows 2000
Visual Basic 6.0
DB2 UDB 7.2.1

Thanks in advance for any help.

James.

 

[Shaixpeare]

Hi James,
One quick thing you can try off the top of your head is when setting up your DB2 ODBC database source, there is an option for optimizing for Microsoft VB & Access. However, I've worked with several VB/DB2 systems and if there are performance problems, generally it's the backend database that needs to have its statistics updated or tables reorg'ed. This is of course assuming that your SQL is tuned and you aren't doing anything bone-headed in your code like executing statements inside a loop when they don't need to be, etc...Hope this helps