Hi again
Thanks for the feedback. I will try and investigate further based on your
feedback. So far I have updated the index statistics and the seems to make
minor improvements. I thought the indexes was recreated (and thus the
statistics) when it was restored.
Regarding the .GDB i doubt this as
Hei Jardar, I have never even heard of Nortek before!
>We have DB of about 40GB where transaction counter exceeded max and we
had to backup and restore to get the db back up an running.
>However after doing this we have had trouble where the DB consumes 25%
CPU (100% on one core). This
Hi again
A bit more details. I found the query the slows this down and it is a query
that includes blob data. If I adjust the query to cast the blob to varchar
first the query executes 30 timers faster. I will try to change my queries
to fix this.
However I still wonder why this suddenly became
Den 28.10.2015 20:56, skrev Jardar Maatje jardar.maa...@nds.nortek.no
[firebird-support]:
Hi again
A bit more details. I found the query the slows this down and it is a
query that includes blob data. If I adjust the query to cast the blob
to varchar first the query executes 30 timers