Packet size & response time with parametized SQL

[valeryf]

ASE 11.9.2

1) Network packet size:
How to specify it. My ASE has default to 1024 and real packets are always 512 with dll?

2) Response time on a lan:
Response time quite immediate with standard SQL and 1-2 seconds with parametized request. Seems to be ASE response problem. Is there any parameter to tune?

Valéry

[Guest]

1) In the current implementation you can obtain a connection handle with ISQLConnection.getOption(eConnNativeHandle) method. You can use this handle in direct calls of Open-Client API functions. For example, ct_con_props(conHandle, CS_SET, CS_PACKETSIZE, ... ) can configure a size of TDS packets.

This feature will be also added to the next releases.

2) A non-parametrized query is very quick because a unidirectional non-caching datasets doesn't fetch all records from the server. They perform a fetch by demand (when you call Next method).
A parametrized query needs a time to be executed by the server (to perform a WHERE search condition). You can create indices to increase a database performance.

[VISOCO Support]