VSERVER, multi-user, READING BLOBs SQL vs API

[Ruslan Zasukhin]

On 5/22/12 8:50 AM, "Fabian Kneubuehl" <support at ysd.ch> wrote:

> Hi
> 
> Other question: is it also important, in the context of multiuser operation,
> to avoid the table class READING BLOBs and Pictures???

Hi Fabian,

Working with really remote server, SQL always will win, because
    SINGLE command send and come back.
    using API way, usually means many commands that walk in NETWORK


Also thinking about RECORD LOCKs, which exists ReadOnly,
Also answer is YES, better to use Vcursor, because you safe from anomalies
described in books for multi-user without locks ...


-- 
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]