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

[Fabian Kneubuehl]

OK, Ruslan

It was only for my interest (has reading a BLOP/Picture from DB an effect to
DB errors). I removed ALL VTable stuff from my application with one
exception, retrieving number of records of a table (or is SELECT Count(*)
FROM t as fast as myDB.Table(t).RecordCount?)


Best 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 23:04
An: valentina at lists.macserve.net
Betreff: Re: AW: VSERVER, multi-user, READING BLOBs SQL vs API

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

Hi Fabian,

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

And ...

Once again ... Very very aloud I want to repeat:

    IF you use vserver,
    than more in such HOT multi-user as you do
    forget, just forget about VTABLE class !!!!!

I repeat this may be 5th time for the last month or so.

=======
No need to love VTABLE class so much.

In my first answer I have underline record locks.
I have underline that working with SQL you get

    ONE COMMAND  ---------->   ONE COMMAND


Working with API you must send MANY commands, Which break atomic nature

THIS IS very critical issue.

This is not just "more suitable"  ...



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