Subject | Re: [firebird-support] Re: Firebird 2.0 Indexing |
---|---|
Author | Brad Pepers |
Post date | 2005-06-01T23:00:56Z |
buppcpp wrote:
design. For a single user database you wouldn't have to worry about
locking at all or could use something simple like a total database level
lock or table level locks. This will win for single users or low
concurrency needs *but* try it when you have many users or have a high
concurrency use and the coarse-grain locking will fall on its face.
--
Brad Pepers
brad@...
> But, as far as Firebirds' design target of high-concurrencyThis shouldn't be hard to understand. There are always trade-offs in
> read/write databases. It seems pretty hard to reach that if
> Firebird is crawling under a single-user.
design. For a single user database you wouldn't have to worry about
locking at all or could use something simple like a total database level
lock or table level locks. This will win for single users or low
concurrency needs *but* try it when you have many users or have a high
concurrency use and the coarse-grain locking will fall on its face.
--
Brad Pepers
brad@...