Hello, Tiberiu!
Monday, April 2, 2012, 10:33:43 AM, you wrote:
TH should I use TACommit as default action for TIBTransaction ?
TH object trans: TIBTransaction
TH DefaultDatabase = database
TH DefaultAction = TACommitRetaining
DefaultAction how to end transaction, when
IdleTimer is
Morning Mark,
On 31/03/12 17:20, Mark Rotteveel wrote:
I disagree, the application (or application developer) should do that
(preparing statements every time it needs it). It is the driver and/or
connection pool that should keep a pool of prepared statements (see
section 11.6 of JDBC 4.1)
Thank you for your time ...
I will do some serious reading and testing !
Tiberiu
From: Dmitry Kuzmenko
Sent: Monday, April 02, 2012 10:03 PM
To: firebird-support@yahoogroups.com
Subject: Re[2]: [firebird-support] OIT / NT
[Non-text portions of this message have been removed]
Thank you for your time ...
I will do some serious reading and testing !
And make your life easier by using some kind of monitoring/tracing
stuff, which actually shows you what's really happening behind the
scene. In one occasion, when tracing a third-party application, an
implementation of
If B_TABLE.VALUE2 never contains 'X' and half of A_TABLE.VALUE1 are 'Y'
what would be the cost of executing this statement? A_TABLE.VALUE1 is
indexed and B_TABLE.VALUE2 does not have an index.
Would it be half of A_TABLE rows times all of B_TABLE rows? Or would
the Not Exists statement be
If B_TABLE.VALUE2 never contains 'X' and half of A_TABLE.VALUE1 are 'Y'
what would be the cost of executing this statement? A_TABLE.VALUE1 is
indexed and B_TABLE.VALUE2 does not have an index.
Would it be half of A_TABLE rows times all of B_TABLE rows? Or would the
Not Exists statement be
Hello,
I've an old Firebird 1.5 database that has in one of its tables a field defined
like this:
...
myfield BLOB SUB_TYPE TEXT SEGMENT SIZE 512,
...
The database has grown so much (about 34 Gb size) that any maintenance task has
become a big trouble. The proposed workaround is to compress