Re: [firebird-support] UPDATE to same record causing heavy disk I/O

On Tue, Dec 22, 2015 at 2:17 PM, Caroline Beltran caroline.d.belt...@gmail.com [firebird-support] < firebird-support@yahoogroups.com> wrote: > > > Since I began using Firebird, I have kept my transactions (type > concurrency) very short and then call COMMIT immediately afterward. This > has

Re: [firebird-support] UPDATE to same record causing heavy disk I/O

Hi Ann, >Just curious, why do you say both "COMMIT" and "end transaction" - Commit ends the transaction. Yes you are right. I shouldn't have said "end transaction" but I will answer your question why. I use the IBPP library for C++ and you create a pointer to the transaction. Immediately

[firebird-support] UPDATE to same record causing heavy disk I/O

Since I began using Firebird, I have kept my transactions (type concurrency) very short and then call COMMIT immediately afterward. This has worked very well. I recently had the need to perform more complex processing and what I did was to keep everything short and modular. But I am now seeing

Re: [firebird-support] Numeration without hole, Is right Before Insert Trigger?

On Tue, Dec 22, 2015 at 9:40 AM, Luigi Siciliano luigi...@tiscalinet.it [firebird-support] wrote: > >I must assign a serial number, without hole, in a column of a fiscal > document. I must assign the number only when I know if the document is > complete >

Re: [firebird-support] UPDATE to same record causing heavy disk I/O

On Tue, Dec 22, 2015 at 2:17 PM, Caroline Beltran caroline.d.belt...@gmail.com [firebird-support] < firebird-support@yahoogroups.com> wrote: > > > Since I began using Firebird, I have kept my transactions (type > concurrency) very short and then call COMMIT immediately afterward. This > has

[firebird-support] Numeration without hole, Is right Before Insert Trigger?

Hello, I must assign a serial number, without hole, in a column of a fiscal document. I must assign the number only when I know if the document is complete and I think the right moment is on a Before Insert Trigger for the table. Is right or the insertion can fail? If not right, when I must