At 09:46 AM 26-11-00 -0500, you wrote:

>Kay Schubert wrote:
>
> > Hello Toni,
> > do you understand that IB executes queries as a whole ? Only one query
> > at a time will be processed, and all other queries are blocked until the
> > current query completes.
>
>Are you sure? I just executed a "short" query while a "long" query was
>executing
>and the short query came back pronto. Did I misunderstand your point?
>
>Rea

If you do, then I do too. In fact, I recall threads on the mers list where
InterBase was blagged for NOT being able to serialize queries. Perhaps you
could clarify, Toni. Are you perhaps referring to what occurs when all
transactions are set Read Committed WAIT ?

Helen


All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________
When many eyes consider your database support problem, you
benefit from the responses of your peers. We all benefit because
our knowledge base grows.

I will not respond to private requests for free support.
_______________________________________________________