VCursor lock question

Ruslan Zasukhin ruslan_zasukhin at valentina-db.com
Sat Oct 5 14:51:38 CDT 2013


On 10/5/13 3:03 PM, "Joseph Morgan" <joseph at checkos.com> wrote:

> Hi if you are using vserver, shouldn't vserver lock the records for you
> automatically? 


Hi Joseph,

MySQL and postgreSQL have only client-side cursors.

This cursors are read only.
They return result records into RAM of computer.

Server not keep any locks after that.

Same in Valentina Server.


------
Valentina Server additionally, have ServerSide cursors.
Which can be ReadWrite

In this case, developer can yet control few optimisations,
E.g. KForwardOnly.




-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]




More information about the Valentina mailing list