Re: [firebird-support] question cte separately

2017-05-03 Thread setysvar setys...@gmail.com [firebird-support]
> Hello, > > at the moment, I’m in struggle with a CTE: > > for with recursive ok as > (select a.pos, b.kennzeichen, b.price, b.id from t_l_prkom_grp a inner join > t_l_prkom_grp_pos b on a.id = b.id_kom_grp where a.id_kom = :id_kom > union all > select c.pos, d.kennzeichen, d.price, d.id from t_l_

Re: [firebird-support] FB persistent connections on php-fpm

2017-05-03 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 2017-05-03 19:07, Rudi Feijó rudi.fe...@multidadosti.com.br [firebird-support] wrote: > As of late, we have been experiencing with persistent connections on > our > backend. This is justifiable, we have a very high number of connection > requests (lots of requests from lots of users). > > We

[firebird-support] FB persistent connections on php-fpm

2017-05-03 Thread Rudi Feijó rudi.fe...@multidadosti.com.br [firebird-support]
As of late, we have been experiencing with persistent connections on our backend. This is justifiable, we have a very high number of connection requests (lots of requests from lots of users). We are using PHP-FPM connecting on firebird3 superserver. We quickly run into memory usage issues - t

Re: [firebird-support] Re: UDF and server crashes on linux

2017-05-03 Thread Tomasz Tyrakowski t.tyrakow...@sol-system.pl [firebird-support]
On 03.05.2017 o 09:28, hv...@users.sourceforge.net [firebird-support] wrote: > ---In firebird-support@yahoogroups.com, wrote : > > Tested on FB 2.5.7 and 3.02 ubuntu_x64 14.04 (two different machines); > On windows fbx64 works ok. > > udf return integer by value. > > scenario: >

[firebird-support] Re: UDF and server crashes on linux

2017-05-03 Thread hv...@users.sourceforge.net [firebird-support]
---In firebird-support@yahoogroups.com, wrote : Tested on FB 2.5.7 and 3.02 ubuntu_x64 14.04 (two different machines); On windows fbx64 works ok. udf return integer by value. scenario: more than 2 connections to db sql : select count(*) from table where validfield(field) = 1 on each co