Subject | Re: Firebird 2.0 Indexing |
---|---|
Author | buppcpp |
Post date | 2005-06-01T23:10:34Z |
No one here is talking about a single-user DATABASE, but a single-user
on a multi-user database.
on a multi-user database.
--- In firebird-support@yahoogroups.com, Brad Pepers <brad@l...> wrote:
> buppcpp wrote:
> > But, as far as Firebirds' design target of high-concurrency
> > read/write databases. It seems pretty hard to reach that if
> > Firebird is crawling under a single-user.
>
> This shouldn't be hard to understand. There are always trade-offs
in
> 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@l...