Arc lot faster than VO

[former_member1263996]

Hi,

I ran an script in arc ver. 10 and takes 1.5 Minutes, I ran in VO using:

adssqlserver, AdsExecuteSQL, AdsExecuteSQLDirect and it takes around 31 minutes, using client and server ver. 10.

Where do I need to look in VO in order to get arcs time?

Building a dot net could not be the solving this time because I need to use the same connection as VO program.

Thanks.

[joachim_drr]

which version of ARC? It might be that a newer ARC optimizes the statemtns much better.

[former_member1263996]

Ther Arc is a bit older than the ace dlls.

Arc 10.0.0.3

ACE in VO program 10.10.0.17

[former_member1263996]

I just implement a test in dot net using the Advantage.Data.Provider ver. 10.0.2.3 and the same script takes 28 minutes versus 1.5 from Arc and 35 in VO.

I though the server receive the script and execute it there and the only difference should be the communication time, Am I correct?

[joachim_drr]

ARC does not transfer all records. If you press ctrl-down in ARC, it jumps to the last record and thus has to process the complete data - this will take the same ~30min.

[former_member1263996]

Joachim,

I'm not expecting a cursor back, this is an screen from arc. Please let me know if having the whole script could help.

in VO using dotnet adsdataprovider it took 1,736 secs aprox. 30 minutes.

Thanks.

[joachim_drr]

without a cursor, the execution time should be similar. Really strange issue.

[former_member1263996]

This is the matter, now I do not know if every operation with the database, I do in VO or .NET could be 25 times faster in Arc (Delphi).

Thanks.