Re: [firebird-support] Question about multithread: readonly query in a 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. ++ 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/
Re: [firebird-support] Question about multithread: readonly query in a single transaction
Hi Dimitry, is this true? I read many times that this is not safe. I remember that i read this also on this group and noone say something different. Especially one thread read some portion of data when another try to retrive different portion i know that there is statement id, transaction id, connection id.but.. If this is realy safe, this can change many things from my POV. I realy need confirmation. Regards,Karol Bieniaszewski null
Re: [firebird-support] Question about multithread: readonly query in a single transaction
Ok thanks all for your answers, You have confirmed that I thought Marco Il giorno mar 18 set 2018 alle ore 17:00 Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] ha scritto: > 18.09.2018 16:51, Marco Andreolli dra...@gmail.com [firebird-support] > wrote: > > For example if I would like execute two query at the same time, in > parallel mode without > > serialization, I have to use two connection!!! > >Yes. Two connections is the only way to make two queries run in > parallel. > > -- >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 > > > >
Re: [firebird-support] Question about multithread: readonly query in a single transaction
18.09.2018 16:51, Marco Andreolli dra...@gmail.com [firebird-support] wrote: > For example if I would like execute two query at the same time, in parallel > mode without > serialization, I have to use two connection!!! Yes. Two connections is the only way to make two queries run in parallel. -- 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/
Re: [firebird-support] Question about multithread: readonly query in a single transaction
Ok that is what I would like to be sure. For example if I would like execute two query at the same time, in parallel mode without serialization, I have to use two connection!!! Il giorno mar 18 set 2018 alle ore 14:06 liviuslivius liviusliv...@poczta.onet.pl [firebird-support] < firebird-support@yahoogroups.com> ha scritto: > > > Hi, > > no, you must use separate connection fo this. fbclient.dll is thread safe, > but thinking about thread safe in a level of connection or transaction is > not releated here. > > If something was changed in Fb3 i am realy interested. > > Regards, > Karol Bieniaszewski > >
Re: [firebird-support] Question about multithread: readonly query in a single transaction
Hi, no, you must use separate connection fo this. fbclient.dll is thread safe, but thinking about thread safe in a level of connection or transaction is not releated here. If something was changed in Fb3 i am realy interested. Regards,Karol Bieniaszewski null
Re: [firebird-support] Question about multithread: readonly query in a single transaction
17.09.2018 15:50, Marco Andreolli dra...@gmail.com [firebird-support] wrote: > Is it safe run multiple (only select) query in separated thread using the > same transaction? It is safe but it is pointless. > I should use a different transaction? or even different connection? It depends on what you want. > PS: fbclient.dll guarantee threading safe operations at transaction or > connection level? It serialize all FB API calls on connection level by mutex. -- WBR, SD.
[firebird-support] Question about multithread: readonly query in a single transaction
Hi everybody, I have a simple question, I would execute a query (select) in one separated theread. Is it safe run multiple (only select) query in separated thread using the same transaction? I should use a different transaction? or even different connection? I'm a delphi developer and I use fbclient.dll and firebird 2.5 PS: fbclient.dll guarantee threading safe operations at transaction or connection level? Thanks in advance Marco