Awegon_15

PI-OLEDB Performance: VB6 vs VB.Net 2005

Discussion created by Awegon_15 on May 21, 2009
Latest reply on May 22, 2009 by Awegon_15

Dear All,

 

I am developing a little application in VB.net to send sql queries to a PI server.

 

On the same workstation:

  • Using PIOLEDBTester.exe (VB6) provided with PI OLEDB, my SQL request takes 10 seconds to get the result.
  • On the other hand, when I use "PIOLEDBWinApp1" (VB.Net 2005) provided with PI OLEDB, it takes 20 seconds.

NB: my SQL query gets around 100000 records (string records).

 

Do you know why the performance are not the same and How to get better performance using VB.net (performance/speed is really important for this application)? Do you have other Vb.net using oledb examples?

 

Thanks in advance for your help.

Outcomes