Slow performance on internet connection

[EderWillian]

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 ?

[AndreyZ]

Hello,

Please specify the code you used to measure speed of query executing in Delphi XE.