Re: ODP: [firebird-support] Question about multithread: readonly query ina single transaction
19.09.2018 13:26, Karol Bieniaszewski liviusliv...@poczta.onet.pl [firebird-support] wrote: > Is something like this safe? Yes. But it has no performance difference from the case when everything happen in single thread. -- WBR, SD. ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ Yahoo Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
ODP: [firebird-support] Question about multithread: readonly query ina single transaction
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.
