Hi,
I'm testing delphi OmniThreadLibrary with Firebird 2.5.1 and FibPlus 7.0.
I'm doing a writing test, trying to find the best way to do multithreading
writing tasks, for example:
With two different threads, with two different connections and transactions
doing an update to the same record:
fo
Hi,
The links on the official firebird web page for the Firebird 2.5.2 RC1
Windows x64 are down (http://www.firebirdsql.org/en/firebird-2-5-2-rc1/).
Thanks.
Jaume
[Non-text portions of this message have been removed]
Hi,
when i execute a long query with Firebird 2.5.2 with various LEFT JOIN to
procedures and i get a plan like this:
PLAN
JOIN *(* *)*
*(*CUSTOMERS INDEX (CUSTOMERS_PK)*)*
*(*PROCEDURE_1 NATURAL*)*
*(*PROCEDURE_2 NATURAL*)*
I don't undestand what kind of operation is executed between a
Well i used wrong words then, i don't understand the description of the
query execution. I would like to understand to know why it performs slowly:
PLAN
JOIN()(CUSTOMERS INDEX (CUSTOMERS_PK))(PROCEDURE_1 NATURAL)(PROCEDURE_2
NATURAL)
What is done between the JOIN set, the CUSTOMERS set and th
Hi,
I would like to know if it's possible to trace, with the Trace API,
statements that are in execution when a connection is closed.
The practical use for this is when a statement is too slow that makes the
user to kill the application. I've tried to simulate this by killing the
application when
Hi,
is it possible to commit a transaction that is hanged in the
MON$TRANSACTION table by ID?
I've seen that i can close a connection in MON$ATTACHMENTS by deleting a
record, but if i want to commit some of the transactions of this hanged
connection, can i do it in any way?
Thank you
Jaume
rd-support] :
>
>
> Hi,
>
> did you mean rollback? not commit?
>
> regards,
> Karol Bieniaszewski
>
> W dniu 2016-12-14 17:44:16 użytkownik Jaume Llunell Gómez
> jaumellun...@gmail.com [firebird-support] com> napisał:
>
>
> Hi,
>
> is it possible to
Hi,
I would like to know if the TempCacheLimit parameter in SuperClassic is
like Classic or like SuperServer? So if it's per client connection or it's
for server process?
And if it's like SuperServer, is there any problem in setting this value to
1 GB if i have this memory free or should it be an
Thank you very much. 2 vs 1, but in this case I asume that Dmitry wins.
I'll check the optimized configuration files.
Jaume
2014-07-07 20:41 GMT+02:00 Dmitry Yemanov dim...@users.sourceforge.net
[firebird-support] :
>
>
> 07.07.2014 21:14, Thomas Steinmaurer wrote:
>
> >> I would like to know
Hi, i would like to understand this plan
PLAN (TABLE1 ORDER TABLE1_IDX1 INDEX (TABLE1_UK))
And the select that generets it is this one:
SELECT first 1 PREU_COST
FROM TABLE1
WHERE ARTICLE = :p_article
AND DATA <= :P_DATA
AND DIVISA = :P_DIVISA
AND PREU_COST >0
ORDER BY DATA DESC,ID
Thank you very much Dimitry
2014-08-30 10:41 GMT+02:00 Dmitry Yemanov dim...@users.sourceforge.net
[firebird-support] :
>
>
> 30.08.2014 11:25, Jaume Llunell Gómez wrote:
>
> > Hi, i would like to understand this plan
> >
> > PLAN (TABLE1 ORDER TABLE1_IDX1 INDE
11 matches
Mail list logo