craigmas...@btinternet.com wrote:
Can anyone help with how to detect if Firebird is installed on a server? A
recent health check here has detected that an older version of one of our
applications used to use Firebird and there are fragments that need removing.
However, all attempts to find
On 13-8-2013 06:41, Maya Opperman wrote:
Mark Rotteveel wrote:
I am unable to reproduce it. Could you create a simple reproduction script
that creates the table, adds the testdata and includes the query?
My reproduction is:
CREATE TABLE int_date_table
(
intfield INTEGER,
craigmas...@btinternet.com wrote:
Can anyone help with how to detect if Firebird is installed on a server?
A recent health check here has detected that an older version of one of
our applications used to use Firebird and there are fragments that need
removing. However, all attempts to find
Hello.
I am trying to increase the speed of my queries.
Firebird 2.5
Windows Server 2008
32 GB RAM
I use 10GB of ram as a ram disk drive.
I wrote query that takes 2:45 minutes running _*without*_ the
TempDirectories=R:\TEMP (ram disk drive)
and the same query takes 1:13 minutes running
Hugo,
Hello.
I am trying to increase the speed of my queries.
Firebird 2.5
Windows Server 2008
32 GB RAM
I use 10GB of ram as a ram disk drive.
I wrote query that takes 2:45 minutes running _*without*_ the
TempDirectories=R:\TEMP (ram disk drive) and the same query takes 1:13
Sean,
I understand what you are saying.
But, my question is, or should be, more generic.
Something like: If I have a lot of RAM available, how could I use it in
a way to increase the database speed (specially queries).
I found out that chaging DefaultDbCachePages from 75 to 750 the queries