A Couple of Questions

[Ruslan Zasukhin]

on 1/6/04 1:08 PM, Robert Brenstein at rjb at rz.uni-potsdam.de wrote:

>>>>  But you have not answer, Ken.
>>>>  You use client-side cursors?
>>> 
>>>  For SQLSelect() I'm using server-side cursors. The problem comes when I use
>>>  SQLSelectRecords(), which AFAIK doesn't have the ability to set server-side
>>>  or client-side, right?
>> 
>> Right, it uses client side cursor, because it need only read.
>> 
>> And I was sure that SQLSelectRecords() will never be used on big selections.
>> 
> 
> Do I read it correctly that SQLSelectRecords in the server version
> creates a cursor on the client side?

More correctly:

    it create client-side cursor.

> Since the point of SQLSelectRecords is to send only the data, it would be
> logical to create the temp cursor on the server and pass on only the data. Or
> am I missing something?

But cursor itself send only data, Robert.

Here there is no overhead.

And when data arrive to to client,
The SQLSelectRecords() build string in special format.

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------