Subject | FB2 multi threading |
---|---|
Author | rj1102 |
Post date | 2010-03-08T19:57:08Z |
Hi Firebird lovers,
I'm using Firebird 2.5 RC2, installed with default configuration on Windows.
I've just tried to execute queries from threads for the first time.
My conclusion is:
If I execute two long running queries from different threads, but using the same database connection, those queries will be executed serially (i.e. the second query will wait executing until the first one has finished).
If I execute two long running queries from different threads, and using different database connections, those queries will be executed simultaneously.
Is this conclusion correct or can I configure somehow that queries always can run simultaneously?
Will this behaviour change with Firebird 3 (and if yes, in which way)?
Kind regards,
Robert
I'm using Firebird 2.5 RC2, installed with default configuration on Windows.
I've just tried to execute queries from threads for the first time.
My conclusion is:
If I execute two long running queries from different threads, but using the same database connection, those queries will be executed serially (i.e. the second query will wait executing until the first one has finished).
If I execute two long running queries from different threads, and using different database connections, those queries will be executed simultaneously.
Is this conclusion correct or can I configure somehow that queries always can run simultaneously?
Will this behaviour change with Firebird 3 (and if yes, in which way)?
Kind regards,
Robert