I need to detect where a firebird installation is on windows so I can auto copy
my UDF there. How can I find this out? It seems to have a different location
per windows version and/or firebird version.
Kind Regards,
Robert.
Robert,
I need to detect where a firebird installation is on windows
so I can auto copy my UDF there. How can I find this out? It seems
to have a different location per windows version and/or firebird version.
You can retrieve the path from the Windows Registry, it is located in
No, sorry, I meant to say that every reference I have ever found
has suggested the correct way to move a FB database from one
machine to another is to simply copy the FDB file while the server
is down.
Oops, that's not good advice. Although this may be safe, it may
also not be (depending on
I need to detect where a firebird installation is on windows so I can auto
copy my UDF there. How can I find this out? It seems to
have a different location per windows version and/or firebird version.
There can be several Firebird servers installed on single pc, so which one do
you want ?
Stefan Heymann wrote:
It also requires you to stop the server, which may be a nuisance if
there are also other databases in use.
AFAIK, after a FULL shutdown you can also access the .fdb file on a
file basis. So you don't have to stop the entire service.
You're right; in Firebird 2.0 and
I cannot find any reference material on the options available to the windows
installer. I mainly want to ensure that fbclient.dll gets into the system
folder along with a copy to gds32.dll this is to allow iboconsole to work
nicely. I have found out how to run the install silently now I just
Not sure if I'm getting the correct error message or why I can't add a
unique constraint:
Invalid insert or update value(s): object columns are constrained - no 2
table rows can have duplicate column values.
attempt to store duplicate value (visible to active transactions) in unique
index
Hello guys,
I found some info about problems with performance when FB is running
on Win2008R2 which is domain controller.
But in my case is it not DC, but the performance is the worst I met.
It is new server running 10GB of RAM, RAID, ... it is quite new
server box.
It cannot be, that
It is a requirement of systems which we install on that we have only one
firebird instance. This saves a lot of problems.
Check for long running transactions.
Test: disconnect everithing from database and run a gfix -sweep.
If you solved your problem you have long running transactions
Em 20/01/2014 20:51, Roland Turcan k...@rotursoft.sk escreveu:
Hello guys,
I found some info about problems with performance
Not sure if I'm getting the correct error message or why I can't add a
unique constraint:
Invalid insert or update value(s): object columns are constrained - no 2
table rows can have duplicate column values.
attempt to store duplicate value (visible to active transactions) in unique
index
I found some info about problems with performance when FB is running on
Win2008R2 which is domain controller.
But in my case is it not DC, but the performance is the worst I met.
It is new server running 10GB of RAM, RAID, ... it is quite new
server box.
It cannot be, that
Now I know the values in the field in question are unique - I have only 3
records.
But when I delete all the records from the table, I still get the above message.
SL Are there other active connections? Have they committed all transactions?
SL FB Indexes contain information for **all active
Now I know the values in the field in question are unique - I have only 3
records.
But when I delete all the records from the table, I still get the above
message.
SL Are there other active connections? Have they committed all
transactions?
SL FB Indexes contain information for **all
Hi.
I am facing a similar situation.
32GB RAM
Dell PowerEdge R420
Intel Xeon CPU E5-2609 two processors 2.40ghz 8 cores
RAID
Firebird 2.5.2 do not use the available resources of the server
even I try to login to the server just one user.
I am using SuperClassic
I felt a little diference by
At 02:01 p.m. 21/01/2014, Hugo Eyng wrote:
As Firebird do not use available RAM I created a RAM DRIVE with 10GB and
pointed parameter 'TempDirectories' (firebird.conf) to this RAM DRIVE, but FB
just uses it rarely in very big 'SELECT'. OK, when FB uses the RAM DRIVE it
increases a SELECT speed
Guten Tag Roland Turcan,
a large Raid Stripe Set can be a real showstopper for Databases
what are your settings for
Database Page Size
and for the Raid
What Type of Raid 1,5,10
Size of the Stripe Set
Hello guys,
I found some info about problems with performance when FB is running
on
18 matches
Mail list logo
