Can i connect Firebird with Jhipster because jhipster didn't show i can use
firebird db
> 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 transactions are assigned a unique ID,
>
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
//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
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.
--
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
El
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]
https://groups.yahoo.com/neo/groups/firebird-
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
---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 first 100 *
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 < 1000)
10 matches
Mail list logo