Hello

A query using IBX IBSQL component, takes 20 seconds to prepare over a RAS connection. The same query takes 0 seconds over a LAN.
Fetching the result set using both RAS and a LAN connection gives good response accounting for the different bandwidths.

Can the initial prepare be speeded up on the RAS connection?
Would using a stored procedure help?

Regards

Jason Berry
Initial Systems


This message has been sent from Initial Electronic Security Systems Ltd.

Initial Electronic Security Systems
Shadsworth Road
Blackburn
BB1 2PR
United Kingdom
Tel +44(0) 1254 688688

This e-mail message and any attachments are confidential
and are intended for the use of the addressee only. If you
are not the addressee you should not copy or use them for
any purpose, nor disclose their contents to anyone else.
If you believe you have received this e-mail by mistake please
notify us immediately by telephoning +44 (0) 1254 688688.


[Non-text portions of this message have been removed]