Re: [firebird-support] Question about multithread: readonly query in a single transaction

2018-09-19 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
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

Re: [firebird-support] Question about multithread: readonly query in a single transaction

2018-09-18 Thread liviuslivius liviusliv...@poczta.onet.pl [firebird-support]
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,

Re: [firebird-support] Question about multithread: readonly query in a single transaction

2018-09-18 Thread Marco Andreolli dra...@gmail.com [firebird-support]
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

Re: [firebird-support] Question about multithread: readonly query in a single transaction

2018-09-18 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
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.

Re: [firebird-support] Question about multithread: readonly query in a single transaction

2018-09-18 Thread Marco Andreolli dra...@gmail.com [firebird-support]
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] <

Re: [firebird-support] Question about multithread: readonly query in a single transaction

2018-09-18 Thread liviuslivius liviusliv...@poczta.onet.pl [firebird-support]
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

2018-09-18 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
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

[firebird-support] Question about multithread: readonly query in a single transaction

2018-09-17 Thread Marco Andreolli dra...@gmail.com [firebird-support]
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