Re: [firebird-support] Read Only Transaction

> On Mar 8, 2017, at 7:17 AM, Aldo Caruso aldo.car...@argencasas.com > [firebird-support] wrote: > > > > Thanks for your answer. > > Regarding the "blob not found" error, there is a thread about this issue [1] > > Nevertheless, I believe that RO/RC

Re: [firebird-support] FIREBIRD PIVOT function or Matrix

So write yourown udf in your favourite language or write stored procedure eg. make_crosstab(sql varchar(500)) which parse sql and create crosstab selectable procedure in fly from given sql. You will be able to select * from crosstab as in postgres. -- regards, Michał Kurczabiński

Re: [firebird-support] Re: firebird 3.0 ten times slower than 2.5 ?

//2.5.7 Database header page information: Flags 0 Checksum12345 Generation 37 Page size 16384 ODS version 11.2 Oldest transaction 26 Oldest active 27

Re: [firebird-support] Re: firebird 3.0 ten times slower than 2.5 ?

08.03.2017 12:20, Michal Kurczabinski michk...@gmail.com [firebird-support] wrote: > is still difference between 2.5 and 3.0:for select first 100 * > (now over 100% of time fb 2.5) Show "gstat -h" from both databases. -- WBR, SD.

Re: [firebird-support] Re: firebird 3.0 ten times slower than 2.5 ?

In my box in isql mode ( win7_x64, dedicated ssd drive for databases) default db configuration is still difference between 2.5 and 3.0:for select first 100 * (now over 100% of time fb 2.5) //2.5 SQL> select count(*) from t1; Current memory = 34646136 Delta memory = 0 Max memory = 34728928

Re: [firebird-support] Read Only Transaction

Thanks for your answer. Regarding the "blob not found" error, there is a thread about this issue [1] Nevertheless, I believe that RO/RC transactions are assigned a unique ID, because as I start them the next transaction ID keeps incrementing. [1]

Re: [firebird-support] Re: firebird 3.0 ten times slower than 2.5 ?

Thanks for your answer, perhaps problem is in jaybird-3.0.0-beta-3 used to connection to fb 3. My fb25 client is jaybird-2.2.12 and works fine. -- regards, Michał Kurczabiński

[firebird-support] Re: firebird 3.0 ten times slower than 2.5 ?

---In firebird-support@yahoogroups.com, wrote : Hi, > fb 2.5.7.27050_0_x64 > fb 3.0.1.32609_0_x64 > > same table and data: > ... > > select count(*) from t1 > > //FB 2.5 time 4 sec. > //FB 3.0 time 6 sec > > //now select first 1 mln recs order by id desc > > select

[firebird-support] firebird 3.0 ten times slower than 2.5 ?

Hi, fb 2.5.7.27050_0_x64 fb 3.0.1.32609_0_x64 same table and data: create table t1 ( id integer not null, n varchar(100)) commit alter table t1 add primary key (id) commit //now insert 10 mln recs. execute block as declare i integer; declare v varchar(100); begin i = 0; while (i <