Subject | ODP: [firebird-support] Question about multithread: readonly query ina single transaction |
---|---|
Author | Karol Bieniaszewski |
Post date | 2018-09-19T11:26:50Z |
This are great news!
Does it mean that if i have e.g. 2 threads
And 1 thread do select 300 records and leave other 700 for next packet fetch
And 2 thread do select 300 records from different query and leave e.g. 900 records for future fetch.
And now thread 1 continue fetch and get another packet 300 records
…
Is something like this safe? If yes, this are great news 😊
Regards,
Karol Bieniaszewski
Od: Dimitry Sibiryakov sd@... [firebird-support]
Wysłano: środa, 19 września 2018 11:18
Temat: Re: [firebird-support] Question about multithread: readonly query ina single transaction
18.09.2018 12:33, liviuslivius liviuslivius@... [firebird-support] wrote:
> is this true? I read many times that this is not safe.
Starting from Firebird 2.5 (at least) every API call uses YEntry guard that lock
entryMutext in corresponding attachment.
You can look into jrd/why.cpp for further details.
--
WBR, SD.