| Subject | Re: [firebird-support] read-only select generates 'lock conflict on no wait transaction'? |
|---|---|
| Author | Ann Harrison |
| Post date | 2014-09-19T19:27:32Z |
On Thu, Sep 18, 2014 at 1:00 PM, 'Carlos H. Cantu' listas@... [firebird-support] <firebird-support@yahoogroups.com> wrote:
If you are sure that there will be no data editing, I recommend you to use ReadCommited+ReadOnly transaction, since it will not block garbage collection.Assuming you can live with a little inconsistency in your results. And that the problem is not that someone has introduced a "No Rec Version" condition into the transaction definition.Cheers,Ann