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 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 (performance/speed is really important for this application)? Do you have other using oledb examples?


Thanks in advance for your help.