[firebird-support] Transactions isolation levels and collisions

2017-02-28 Thread Aldo Caruso aldo.car...@argencasas.com [firebird-support]
Hello, I'm trying to understand interactions between transactions with different isolation levels. My environment is Firebird Super Server 2.5 (v. 2.5.2) on Linux Ubuntu 14.04 I'm testing by opening two consoles and running isql-fb on both consoles. On the first one I start a

Re: [firebird-support] Firebird 2.5 classic performance issue on linux64

2017-02-28 Thread Andreas Zeller zel...@lux-medien.com [firebird-support]
Hi guys, I'm just responding one more time because I want to mark this as solved for me: Several things did the trick: * Upgrade Firebird to 2.5.7 (apparently there was a subquery bug in 2.5.4 which wasn't fixed in the debian package) - thanks to LiENUS on IRC. * blockdev -setfra

[firebird-support] Strange behaviour on Update Operation

2017-02-28 Thread trsk...@yahoo.com [firebird-support]
Hi all, I have a strange result when running update operation. I am using TIBSQL from Borland CBuilder 6, Firebird Super Clasic 2.5.2 (64bit) on Windows 7 64 bit. Here are the script from TIBSQL : = Update table1 set field1 = 'abc', field2 = 'abc', field3 = field3 + 1