Got the answer in the below link.
http://stackoverflow.com/questions/30781212/rolling-back-transaction-doesnt-work-with-tpfib-components?noredirect=1#comment49820919_30781212
Solution:
I would also advise you to allocate the one transaction component to all the
datasets (rather than the
Hi Helen, Hi All,
I have one issue with the transaction, let me explain in detail what is
happening...
I am using Delphi 2010 with FIB Plus components ( TpFIBDatabase,
TpFIBTransaction and TpFIBDataSet ), and Firebird as database.
Case 1:
I have an existing customer's database, on which Commit
Having just checked the Fb_lock_print stats now it is up to 65.1%.
I am going to try upgrading to v2.5.4 CS 64bit and will see what happens.
Cheers,
Neil Pickles - n...@csy.co.uk
CSY Retail Systems Limited
I already have it set to 30011 which should be okay compared to the default of
1009.
Cheers,
Neil Pickles - n...@csy.co.uk
CSY Retail Systems Limited
Is it normal for the security2.fdb file to grow to over 200meg with only a
single user defined (SYSDBA).
This was using Firebird 2.1 SuperServer 32 bit for Windows.
Cheers,
Neil Pickles - n...@csy.co.uk
CSY Retail Systems Limited
Thanks Alan,
That's what I thought. I have just checked one installation running v2.1.5
that gets pretty high constant load and it got to 179Meg before I
reinstalled Firebird about 3 months ago and it is already back up to 29Meg.
Cheers,
Neil Pickles - n...@csy.co.uk
CSY Retail Systems
17.06.2015 18:00, 'Neil Pickles' wrote:
Hopefully Dmitry will come up with some answers.
I don't see anything really wrong in the lock print. However, I recall
one improvement to the high mutex ratio committed to v2.1.4, so
upgrading to a newer FB version could be helpful.
Dmitry
Urgent need help.
need finish this project before friday
error message
invalid request BLR at offset @1
function @1 is not defined
module name or entrypoint could not be found
Error while parsing procedure @1's BLR
this happen when i need to use insert data into table that have
Hopefully Dmitry will come up with some answers. He seems to be the man that
knows. Im sure he was one of the IBSurgeon guys at
the recent Prague seminar on performance tuning etc.
Just as an FYI - Dimitry is *not* one of the IBSurgeon guys - he happens to be
the Firebird project's lead
On 18 Jun 2015 01:12:13 -0700, ericfanpheic...@yahoo.com
[firebird-support] firebird-support@yahoogroups.com wrote:
Urgent need help.
need finish this project before friday
error message
invalid request BLR at offset @1
function @1 is not defined
module name or entrypoint could not
What version of firebird is this with?
Cheers,
Neil Pickles - n...@csy.co.uk
CSY Retail Systems Limited
Thanks for the heads up Paul.
Apologies Dmitry, I didn't realise.
Cheers,
Neil Pickles - n...@csy.co.uk
12 matches
Mail list logo