Subject ODP: [firebird-support] Question about multithread: readonly query ina single transaction
Author Karol Bieniaszewski

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.