Roman Rokytskyy wrote:

>Hi,
>
>Thanks for the info. So let's check how we can improve this:
>
>
>
>>The server is FB1.5 and isql. Executing a simple query.
>>
>>
>
>1. start transaction, we cannot avoid it, old delay is 65ms, new delay
>is 65ms
>
>
>
>>
>>
>2. Introduce new method to prepare and allocate SQL string, old delay
>was 50ms + 59ms + 49ms + 83ms (not sure here, the protocol here and at
>the end of the message are different), new delay would be ~60ms
>(assuming the 50ms latency and 10ms for the execution)
>
>

Rather than complicate the protocol with various combined requests, why
not allow batching of requests into a single message? This would let a
single message of { start_transaction, allocate statement, prepare
statement, execute, fetch, fetch, fetch }. The server would batch the
responses (until one failed, of course). This would allow arbitrary and
open ended batching of request types.

--

Jim Starkey
Netfrastructure, Inc.
978 526-1376