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

[Ruslan Zasukhin]

On 5/22/12 4:37 PM, "Fabian Kneubuehl" <support at ysd.ch> wrote:

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

Of course no.

You have asked question about:
    * VTABLE + Read BLOBs

Right?

I have gave you answer...


=======
But if you want to know if this can be related to index error or crashes,
this is ANOTHER question. Right?

In theory also can be possible, because if there is no record locks, and
while user1 send few API commands, another user also can enter between that
commands and e.g. Change current record of Vtable.

Using Vcursor this will not happens.

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