Hello,
I believe it is generally safe to have multiple simultaneously running
instances of Gbak backing up the same server, when all of them read data from
within their own transaction. Is that any different when Gbak is not supplied
with the argument to skip garbage collection? Does that put e
The search term you need is 'data pump'. For example, check out Clever
Components - Interbase DataPump
http://www.clevercomponents.com/products/datapump/index.asp
http://www.clevercomponents.com/products/datapump/index.asp
Clever Components - Interbase DataPump
http://www.clevercomponent
Hello,
My name is Yemane, a DBA at the Catholic University of America. We have an
application called QBICSYSTEMS. We believe that the proprietary database
inbuilt is FIBERBIRD. Apparently we needed to extract the data and migrate it
to our enterprise database systems, Oracle or SQL Server. H
Hi,
i do not know what should happen in your case when FIEL3 is null?
But you can try
WHERE FIEL1=:F1 AND FIEL2=:F2 AND (FIEL3=COALESCE(:F3, FIEL3) ) INTO .. DO
..
regards,
Karol Bieniaszewski
From: mailto:firebird-support@yahoogroups.com
Sent: Wednesday, August 19, 2015 1:29 PM
To: fireb
19.08.2015 14:29, 'Mr. John' wrote:
> This time,adding condition this way WHERE FIEL1=:F1 AND FIEL2=:F2 AND
> * (FIEL3=:F3 OR **:F3 IS NULL) * INTO .. DO ..
>
> is causing query to be much slower ...
>
> this WHERE FIEL1=:F1 AND FIEL2=:F2 AND * (FIEL3=:F3 **) * INTO .. DO ..
> takes *0.563s*
be
ok,thanks
This time,adding condition this way WHERE FIEL1=:F1 AND FIEL2=:F2 AND
(FIEL3=:F3 OR :F3 IS NULL) INTO .. DO ..
is causing query to be much slower ...
this WHERE FIEL1=:F1 AND FIEL2=:F2 AND (FIEL3=:F3
) INTO .. DO ..takes 0.563s
82
19.08.2015 10:26, 'Mr. John' wrote:
> now index is used if I call
> SELECT * FROM MYPROC(...)
> but I use it in other procedures,no join on it just simply SELECT ..
> FROM MYPROC(...) in this case I can see in the plan :
> ...(MYPROC NATURAL)...
That' OK. In complex plans, (MY_PROC NATURAL) just
Hi,thanks for your answer
I remove pCondition variable and use :F3 insead (:F3=NULL means no F3 field
condition,else F3 condition)and I simply have
WHERE FIEL1=:F1 AND FIEL2=:F2 AND (FIEL3=:F3 OR :F3 IS NULL) INTO .. DO
..
now index is used if I call SELECT * FROM MYPROC(...)
but I use i
