>Hi;
>
>I am using FB 2.5.3. in a fast environment (win8 64bit - QuadCore 3.4 Ghz - 8
>GB ram).
>
>If I run this query it goes very very fast and returns 84 records:
>
>Preparing query: select distinct "PROC" from "GEST" where ("GEST"."FSAL"
>between '20080801' and '20080812') order by "PROC"
>Pr
Hi,
Don`t know about specific transactions (can`t imagine the client suddenly
trying to use an externally closed transaction), but you could use the
monitoring tables and kill attachments, which have transactions that were
started too long ago. I expect the other applications can handle network
iss
"select in" does not use indexes. Use EXISTS() instead.
On 18/02/2015 11:25, martin_gorr...@yahoo.es [firebird-support] wrote:
Hi;
I am using FB 2.5.3. in a fast environment (win8 64bit - QuadCore 3.4
Ghz - 8 GB ram).
If I run this query it goes very very fast and returns 84 records:
P
Hi;
I am using FB 2.5.3. in a fast environment (win8 64bit - QuadCore 3.4 Ghz - 8
GB ram).
If I run this query it goes very very fast and returns 84 records:
Preparing query: select distinct "PROC" from "GEST" where ("GEST"."FSAL"
between '20080801' and '20080812') order by "PROC"
Pr
Anyone know if/when CakePHP is likely to work with Firebird again?
Or care to give me some pointers on what needs doing?
Thanks
Perfect!
Thank you very much.
Regards,
Zoran
On 18/02/2015 11:05, Svein Erling Tysvær
svein.erling.tysv...@kreftregisteret.no [firebird-support] wrote:
Note that I removed your right join since your where clause logically
and practically makes it an inner join.
It might nonetheless have been deliberate - sometimes swapping between
in
>I have a query like this:
>
>select
> artikli.a_sif,
> v1.v_txt,
> v2.v_txt,
> coalesce(sum(magkol.k_total),0) total,
> coalesce(sum(magkol.k_nabcen * magkol.k_total),0) vrednost,
> coalesce(sum(magkol.k_nabcen * magkol.k_total),0)/
>coalesce(sum(magkol.k_total),1) nc,
> coale
I have a query like this:
select
artikli.a_sif,
v1.v_txt,
v2.v_txt,
coalesce(sum(magkol.k_total),0) total,
coalesce(sum(magkol.k_nabcen * magkol.k_total),0) vrednost,
coalesce(sum(magkol.k_nabcen * magkol.k_total),0)/
coalesce(sum(magkol.k_total),1) nc,
coalesce(sum(iz