> From: "Carlos M" <[EMAIL PROTECTED]>
> Date: Sun, 8 Oct 2006 23:44:37 +0100
> The locks in REALSQLDatabase (SQLite) is at the DB file level -
> there's no table or record levels.
Exactly.
>> Of course, I'm open to alternate suggestions and strategies
>> for record loading/locking for multi-user systems built with RB.
For example, Valentina Server.
Provides true and effective record-level locks of few types.
Or Postgre,
mySQL ($$$)
> I presume you already know that REALSQLDatabase is for one-user access
> only. If you need multi-user access you must use "REAL SQL Server".
> Don't know if "REAL SQL Server" provides other lock level mechanisms.
Bravo Carlos.
This is similar doubt that I try express few months.
it is not possible to build server using
very single-user db engine. Engine which its author
position as single-user. Engine which has MANY algorithms
built and optimized for single-user access. That algorithms
in multi-user access must be absolutely other.
If SL engine build its "model of transaction" on db level lock,
Then how you can image few parallel transactions? Impossible.
Once on inet I have meet article where author have write:
if you'd know how many there was crying when people have try
to build client/server solutions using MS Access!
But MS Access is so much more powerful of SQL Lite...
--
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]
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
