hello one and all, i am having some weird intermittent problem with the triggers under 1.5.4.4910. basically, a detail table updates an accrual field in the ...
... Check that you don't have any AFTER triggers that are trying to change the NEW values; nor any DELETE triggers trying to refer to NEW values; nor any...
... Sweep ... Thanks, probably a nice idea. How much does the sweep affect the performance (during a sweep)? Maybe that'll explain some of the really sudden...
hello helen, i did check that awhile back and none of those are the case. it is all strict. before insert or update apply NEWs with no reference to OLDs,...
I must have a knack for it...continuing my deployment of Ubuntu+AMD64 we have another problem. This time it's not so serious as we shouldn't have caused the...
... Hi, It depends on amount of records that have to be removed from database. Sweep can take 1 CPU to 100% for a while, but not for long (it takes a little...
... A sweep affects all current connections (superserver) while the sweep is running. A sweep affects only the current connection (classic) while the sweep is ...
I am currently testing firebird 2 and I have found a number of issues with speed in comparison to firebird 1.53. I have even found a number of issues just...
... Maybe I misunderstand (or don't understand 'accrual'), but when you say "no reference to OLDs" I must ask: Don't you use something like new.AMOUNT =...
Dalton, ... version ... What you also compared 1.53 vs. 2.01 32Bit? It is my experience that v2 is MUCH faster than v1.5, running 32bit Windows builds (I know...
Dalton, ... Once more in English (my native tongue, although looking at the above you would never guess it) Have you also compared 1.53 vs. 2.01 32Bit? Sean...
Hi Alexandre, ... It does not seems to work on Classic. You can do that and go to task manager, you'll see all fb_inet_server processes still there. Regards, ...
... I have just one client with FB CS, and don't have it installed on my machine. AFAIK gfix shutdown should work at database level, I imagine that the ...
... That's explain the behaviour... FB < 2.0 does not drop SYSDBA connections to the database. see you ! -- Alexandre Benson Smith Development THOR Software e...
... Hi Vlad, I have been away on business for a week. I try to create in the next days a simple test case with a small database and delphi program to reproduce...
Hi All, I have few tables which have data from hundred thousand of records to millions of records. All these tables either have BLOB subtype 0 or 1. My...
... What was the difference? ... Yes, there are. Some of them are documented in the release notes, section "known compatibility issues / performance". You...
... After making some proper time comparisons it turns out that it was all a figment of their imagination. Surprising what whichful thinking for more speed can...
Hi, ... millions of records. ... main tables? None, there could be some benefit, but only if you do SELECT * always, which you shouldn't be doing anyway. ... ...
I have two intentions over here: 1) My window will have 2 tabs. Main tab is to display details which coming from main table. Second tab is to display picture...
... Hi Peter! The speed difference between your notebook and his server could be due to different PLANs (just prepare statements to compare) or one or more...
Hi, ... from main table. Second tab is to display picture or memo. Only when user clicks on second tab then only I select from the separate BLOB table using ...
