Next beta will have record locks.

Ruslan Zasukhin sunshine at public.kherson.ua
Wed Jul 2 08:11:14 CDT 2003


on 7/2/03 2:48, Frank Schima at frank-list2 at mindstarprods.com wrote:

Hi Frank,

>> Erne, in the same time I want point that although this level 1 "DIRTY READ",
>> exists in the standard of SQL, most mature DBMS like Oracle, Sybase, SQL
>> Serve even DO NOT support it. They explain this that this is very danger way
>> to work with data...
>> 
>> Indeed, this mode of record access can be used in real life only in very
>> special cases, e.g. You want fastest dump of some records, and you do not
>> care about consistency of them.
> 
> Unless I am misunderstanding you, Sybase has always allowed this. It is
> called Isolation Level 0. It is actually useful for getting snapshot
> sum() or average() values in tables which are constantly changing like,
> for example, bank transactions.

I will not bet. You know Sybase better.

But I remember that I have read about this, and Ivan also have told me that
this is written in sybase docs. And this fact did wonder me, because level 0
is easy for implementation.

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------



More information about the Valentina mailing list