Hello

Preparing the same IBX IBSQL query over a RAS connection takes 22 seconds, compared to 0 seconds with a LAN connection.
Subsequently fetching each row of the result set over the RAS connection is quick.

What if anything can I do to speed the prepare operation up?

I thought the interbase server would be passed the SQL text/params and prepare the query. I would have thought this would not require a large amount of bandwidth.

I would be most gratefully if someone could enlighten me. Not with an explanation on what thought did.

Regards

Jason Berry


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]