On 24-7-2015 00:23, conver...@gmail.com [firebird-support] wrote:
Thanks for your insightful response. FWIW, I would like to mention that,
in the same server, we have another database (same size ~7 GB) no one
connects to, it's a restore of the production database from January this
year. This
Existence Predicates NOT IN and ALL May Be Slow
Firebird and, before that, InterBase, have produced incorrect results
for the logical existence predicates ALL and NOT IN for many years.
That problem has been corrected in Firebird 2.0, but the change means
that indexes on the inner tables
Thanks Mark
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]
Sent: Thursday, July 23, 2015 8:22 AM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Upgrade Firebird 1.5.3 to 2.5.4 - CHECK
Constraint Change Question
On Thu, 23 Jul
Thanks Mark
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]
Sent: Thursday, July 23, 2015 7:40 AM
To: firebird-support@yahoogroups.com
Subject: RE: [firebird-support] Migration Guide for Firebird 1.5.3 to 2.5.4
On Thu, 23 Jul 2015 07:16:18 -0500,
Greetings All,
In the Firebird 2 Migration Installation guide
http://www.firebirdsql.org/file/documentation/release_notes/Firebird-2_1_6-Installation.pdf
http://www.firebirdsql.org/file/documentation/release_notes/Firebird-2_1_6-Installation.pdf
on page 8 under the performance section it
Set, thank you for the very detailed response as it is VERY helpful and
informative.
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]
Sent: Friday, July 24, 2015 7:49 AM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Upgrade Firebird
Mark, thanks for the clarification on this. Makes sense now. Appreciate all
the help.
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]
Sent: Friday, July 24, 2015 9:40 AM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Upgrade Firebird
On 24-7-2015 13:25, 'stwizard' stwiz...@att.net [firebird-support] wrote:
Greetings All,
In the Firebird 2 Migration Installation guide
http://www.firebirdsql.org/file/documentation/release_notes/Firebird-2_1_6-Installation.pdf
on page 8 under the performance section it states the following:
Hi there,
Can the connection errors in the log contribute to the increasing gap between
the OAT and NT?
Regards,
-Eduardo
without considering the merits of your problem, I can say that the response
time of the selects depends on more factors: the first and 'the structure of
the indexes on the table but also on how and' written queries. Without know
the details, I can say that the absence of a group by in the presence
Greetings,
Does anyone know where I can get a 64 bit version of the FreeUDFLib.dll?
I know Jeff Overcash (TeamB) has done it per this link, but I have no idea how
to get ahold of him
http://codeverge.com/embarcadero.interbase.general/freeudflib-and-developing-udfs/1083840
Thanks,
snip
As you are using
FB TraceManager, it is a simple mouse-click via the context-menu in the
parsed gstat output to locate the OAT in the monitoring tables.
Thanks Thomas. I've located the OAT in the monitoring tables as you mention.
Can you please elaborate a bit on how to find the
Você é Brasileiro? Estou acompanhando uma mensagem sua no grupo. Se
falar português posso te ajudar melhor, por email, por aqui.
--
Take at look at the HDD usage. Is HDD been used around 100% when slowly
appears?
On 24/07/2015 16:00, conver...@gmail.com [firebird-support] wrote:
Thanks Thomas. Today we had a performance problem about 3 hours ago,
we had to reboot the Windows server to solve it. Prior to the restart,
the
Thanks Thomas. Today we had a performance problem about 3 hours ago, we had to
reboot the Windows server to solve it. Prior to the restart, the OAT-NT gap was
120479. After the restart it was 33.
Interestingly enough, currently the gap is 354354 as I write this. That's
almost three times
Hi,
OAT is an active transaction. You can see it alive if you analyze MON$
snaphot (you can use trial of our FBMonLogger).
So, disconnects are not related with Next-OAT gap - because this gap is
caused by some open transaction which you can easily identify.
However, disconnects can lead
16 matches
Mail list logo