Subject Re: [IBO] updates
Author Geoff Worboys
> Yes, mormally over a fast network it doesn't make
> much of a diffenerce. However, it sure does when
> you have blobs in your tables.

Covered this in a previous post - Blobs are handled separately and
only posted if they have been changed/created. You will still see the
blob-id posted with the main record, but this does not mean the entire
blob was resent.


> Used to AstaServer/Client software, which goes into
> great depth to minimize Server/Client data exchange.
> Which makes sense if you use a slower internet connect.

Presuming that Asta (and the various other solutions available) batch
updates into the same network packets at the client and extract them
at the server then such a solution could offer you performance
benefits in the situations you have been describing. I dont know what
these systems do, I have not used them.

When talking directly to IB/FB you are constrained by the server
capability. And AFAIK it only processes updates as one record per
network package (whereas selects it will batch).


Geoff Worboys
Telesis Computing