Hello Karol, I don't think I understand you fully. Indexed reads a hudreds of
times faster than non indexed. And the table will have millions of records, so
I do need them.
"then this is cheaper to scan table (500 records) then use 400 indexed reads"
What do you mean scan table? How do I do
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)
I've downloaded the FB Replicator and tryed it on my database. When I want to
add it as a souce database I enter path to the DB user pass and click save,
but it gives me the following error:
ISC ERROR CODE: 335544323
ERROR MESSAGE:
file is not a valid database
The problem is that it is
That doesn't help me, cos I need to install replicator on my clients and can't
force them to pay 150$ for it. They just won't buy my software.
Hello Alan, Thank you for your answer. I will download the FB Replicator try it
and see if it will work for me.
That part with the triggers i've already done. I have after I, U, D triggers
for every table and they insert into my replication log table. The problem is
that I used to put the sql
I am writing a two way server - client Firebird replication with a C# app and I
am facing the following problem. I have a log table with the table name pk of
the record and type of the query executet on it. For example if in the sales
table there has been inserted a line with primery key of 4