da-soft - Data Access Technologies

Additional

dbCAP

AnyDAC

ThinDAC

NCOCI8

Topic: IADPhysCommand vs. ADStoredProc

Forum List » AnyDAC » v 1.x General English

irobayna
User

Junior Boarder

Posts: 14

Karma: 0

IADPhysCommand vs. ADStoredProc

Posted: 2007/05/19 08:52

Dmitry,

I am starting to feel somewhat confortable with IADPhysCommand versus using the higher level components.

I was wondering if there are any performance benefits as well?

My demo application "seems" faster when executing the same storec proc via the low level command.

Also, what does DirectExecute mean (under ResourceOptions) ?

Regards,

Isi R

Diman

Admin

Posts: 1496

Karma: 19

Re:IADPhysCommand vs. ADStoredProc

Posted: 2007/05/20 01:14

Hello Isidro

1) You will get some performance gain, when you need to handle big rowsets. It is because TDataSet read / write field data methods add 20%-50% of performance overhead.

But server will execute your queries / stored procedures with the same speed.

2) DirectExecute has meaning just for some DBMS's. At first for MSSQL and Sybase ASA. Setting it to True avoids creation of temporary objects and may create / resolve some issues.

Regards,
Dmitry

Forum List » AnyDAC » v 1.x General English