Re: [firebird-support] Commit MON$TRANSACTIONS by TRANSACTION_ID

2016-12-15 Thread Jaume Llunell Gómez jaumellun...@gmail.com [firebird-support]
] <firebird-support@yahoogroups.com>: > > > 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] <firebird-sup

[firebird-support] Commit MON$TRANSACTIONS by TRANSACTION_ID

2016-12-14 Thread Jaume Llunell Gómez jaumellun...@gmail.com [firebird-support]
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

[firebird-support] Trace API with "*_finish" = true

2016-02-11 Thread Jaume Llunell Gómez jaumellun...@gmail.com [firebird-support]
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

[firebird-support] Understanding a PLAN

2014-08-30 Thread Jaume Llunell Gómez jaumellun...@gmail.com [firebird-support]
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

Re: [firebird-support] Re: Understanding a PLAN

2014-08-30 Thread Jaume Llunell Gómez jaumellun...@gmail.com [firebird-support]
Thank you very much Dimitry 2014-08-30 10:41 GMT+02:00 Dmitry Yemanov dim...@users.sourceforge.net [firebird-support] firebird-support@yahoogroups.com: 30.08.2014 11:25, Jaume Llunell Gómez wrote: Hi, i would like to understand this plan PLAN (TABLE1 ORDER TABLE1_IDX1 INDEX

Re: [firebird-support] Re: TempCacheLimit in Super Classic

2014-07-08 Thread Jaume Llunell Gómez jaumellun...@gmail.com [firebird-support]
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] firebird-support@yahoogroups.com: 07.07.2014 21:14, Thomas Steinmaurer

[firebird-support] TempCacheLimit in Super Classic

2014-07-07 Thread Jaume Llunell Gómez jaumellun...@gmail.com [firebird-support]
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