Slow performance on internet connection
Posted: Wed 04 Apr 2012 13:33
Hi everybody
After migration to Delphi XE and version 5.2 driver, We have some slow performance on a Sql2008R2 server, connected via internet.
Simple querys like 'Select top 1 * from Table Where Record = 1' have an total time to execute about 300 ms (via my softare). If I look at SQLProfiler, the total duration time is 0-10 ms.
If I send the same SQL via SQL Management Studio the profiler time is equal, but the velocity of response is very high.
I'm using:
LibraryName := 'dbexpsda40.dll';
VendorLib := 'sqloledb.dll';
param LongStrings, EnableBCD and FetchAll are setting to True
Can you help me ?
After migration to Delphi XE and version 5.2 driver, We have some slow performance on a Sql2008R2 server, connected via internet.
Simple querys like 'Select top 1 * from Table Where Record = 1' have an total time to execute about 300 ms (via my softare). If I look at SQLProfiler, the total duration time is 0-10 ms.
If I send the same SQL via SQL Management Studio the profiler time is equal, but the velocity of response is very high.
I'm using:
LibraryName := 'dbexpsda40.dll';
VendorLib := 'sqloledb.dll';
param LongStrings, EnableBCD and FetchAll are setting to True
Can you help me ?