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.