Subject Re: [firebird-support] Re: Stored procedure never completes
Author Mark Rotteveel
On 10-8-2013 22:22, esbreidenbach wrote:
> I see the firebird process accounting for 22-25% of my CPU in the task manager (which makes sense because its a quad). I know the last line of delphi code executed is calling the "execute procedure ProcedureName". And as I mentioned, it actually does complete the procedure if I run this data conversion on a smaller number of records, it only seems to hang on larger databases.

It sounds like a lock conflict. What happens if you configure the
transaction with no wait?

Mark Rotteveel