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 s...@ibphoenix.com [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 liviusliv...@poczta.onet.pl [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.



  • [firebi... Marco Andreolli dra...@gmail.com [firebird-support]
    • Re... Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
    • Re... liviuslivius liviusliv...@poczta.onet.pl [firebird-support]
      • ... Marco Andreolli dra...@gmail.com [firebird-support]
        • ... Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
          • ... Marco Andreolli dra...@gmail.com [firebird-support]
    • Re... liviuslivius liviusliv...@poczta.onet.pl [firebird-support]
      • ... Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
        • ... Karol Bieniaszewski liviusliv...@poczta.onet.pl [firebird-support]
          • ... Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
            • ... Karol Bieniaszewski liviusliv...@poczta.onet.pl [firebird-support]

Reply via email to