Ann,
You answer is exactly what I wanted to know. Alle your guesses were right.

Thank you
Dieter

Ann W. Harrison schrieb:

>At 12:02 PM 6/10/2004, Dieter Raith wrote:
>
>
>>I use the API to work with the database. If I issue a "select A,B from
>>TBNAME" all data is
>>moved somewhere to the client. Someone told me that this happens. Is it
>>true?
>>
>>
>
>No. The data is passed to the client one row at a time. The transmission
>across the network is done in packets which may contain several rows
>worth of data. The system picks a reasonable packet size then fills it
>with data for transmission.
>
>
>
>>I can access each row using a cursor. As I know what I am
>>expecting I am not happy to copy the data from one place
>>in memory to another. So I would like to get a
>>pointer to the place where the data reside. Is that possible
>>and availlable?
>>
>>
>
>I'm not entirely sure what you're asking. I've assumed that
>your client is on a different server and you are accessing the
>database over TCP. If that's correct, your data is retrieved
>from the database and packed by the remote protocol server into
>packets for transmission. On the client side, the remote
>interface unpacks the data and returns it to the client row
>by row. In the process, the data is copied twice, but
>the cost of copying pales beside the cost of transmission.
>
>Perhaps you could ask the question again.
>
>Regards,
>
>Ann
>
>
>
>
>
>Yahoo! Groups Links
>
>
>
>
>
>
>
>