AW: VSERVER, multi-user, READING BLOBs SQL vs API

[Fabian Kneubuehl]

Hi Ruslan

OK, But as I understand it is more suitable, but it has nothing to do with
index errors or any other DB crushes mailed in my earlier mails!

Kind regards
Fabian 


-----Ursprüngliche Nachricht-----
Von: valentina-bounces at lists.macserve.net
[mailto:valentina-bounces at lists.macserve.net] Im Auftrag von Ruslan Zasukhin
Gesendet: Dienstag, 22. Mai 2012 14:59
An: Fabian Kneubuehl; valentina at lists.macserve.net
Betreff: Re: VSERVER, multi-user, READING BLOBs SQL vs API

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]


_______________________________________________
Valentina mailing list
Valentina at lists.macserve.net
http://lists.macserve.net/mailman/listinfo/valentina