Subject Re: [IBO] IB_Cursor... how - VPN
Author Helen Borrie
At 11:30 AM 7/09/2006, you wrote:
>Hi Helen
>As an aside to all this, I have a small app running over a VPN (Across
>the web) that uses ib_Query. Would changing it to ib_Cursor also reduce
>some of the traffic caused when running a Query?

"Traffic" translates to requests in one direction and results in the
other. Results are what clients get back as the result of
requests. So, simplistically, if your query is requesting 100,000
rows, the "traffic" is the same.

However, the one-by-one request (ib_cursor) isn't necessarily the
same as far as the network is concerned, theoretically at least. The
network could package multiple rows of a small record structure in a
single packet, whereas the one-by-one fetches would be one (or more)
packets per fetch. I say "theoreticaIly" as I *think* the API does
do something along those lines when it knows the client is going to
buffer the dataset at the client.

>I know I shouldn't run FB over the Interent but in this case the app is
>sufficiently small and performance if good.

Why not test it?