Hi !
Em 16/1/2014 04:13, brucedickin...@wp.pl escreveu:
Hi guys.
Yesterday I was trying to figure out what is the cause of my problem.
And I've noticed that two months ago my colleague added one trigger on
this table. The trigger is:
SET TERM ^ ;
ALTER TRIGGER CLIENT_LM INACTIVE
AFTER INSE
At 07:15 p.m. 16/01/2014, brucedickin...@wp.pl wrote:
>One thing I do not understand. If the trigger has been installend over two
>months ago, why performance degraded just few days ago and not immediatelly
>after the trigger has been activated?
You might be shooting at rainbows. Your collea
We have even restarted the computer and even a backup and restore. So no
way we can have old record versions and the database sill slow.
The slow down is due to hard disk usage.
I tought when are much records and much indices when a record is updated
there is no room for recalculate the indexes.
Wh
32 MB. The page size is in bytes.
If you did not have enough memory, the server will refuse to open the
connection (needing the extra memory) if I remember well.
De : brucedickin...@wp.pl [mailto:brucedickin...@wp.pl]
Envoyé : 15 janvier 2014 14:53
À : firebird-support@yahoogroups.com
Objet : [
Em 15/1/2014 17:52, brucedickin...@wp.pl escreveu:
Regarding the number of pages.
Correct me if I am wrong
(http://www.firebirdsql.org/manual/gfix-buffers.html) but if
Superserver is using 2048 pages and page size is 16384, than computer
must have 32 GB RAM installed. What is happening whe