Hi,
why do you need to slow down query by index?
If you go throught whole table and only some sub percent (REPL) is not looked
for?
consider something like this
VALUE=’RX’ 100 records
VALUE=’YY’ 100 records
VALUE=’XX’ 100 records
VALUE=’AA’ 100 records
VALUE=’REPL’ 100 records
then this is
Hi,
is it possible to restore a database without constraints? Or is there another
way to do this? I just want do delete each primary key in the db.
Regards
Martin
Hi guys,
I have a problem with indexing in FB. Heres the query
select rep$log.pk, tablica_ime, client_number, time_stamp, sql_type,
sql_query, usr
from rep$log
where usr <> 'REPL' and not exists
(select rep$trans.pk from rep$trans where rep$trans.replicated_pk = rep$log.pk)
You just need to use the -i switch with gbak when restoring the database. We
use this when we have a database that has become corrupted and we are then
fixing it with gfix and when it comes to restoring it, it fails due to some
issue with either missing or duplicated data
Cheers,
Neil Pickles
From the first look it seems you run out of resources
I would use a monitoring tool check what happens with the system
(htop/cacti/dstat) also i would migrate from a vm configuration to a real
machine (hardware)