Re: [firebird-support] SQL Optimation best way

On Wed, Nov 4, 2015 at 8:41 AM, 'checkmail' check_m...@satron.de [firebird-support] wrote: > > > two tables > > > > A: > > Field1, Field2, Field3, Field4, Field5 > > > > B > > FieldA, FieldB, FieldC > > > > Now I would like to get the following: > > > >

Re: [firebird-support] Writing to Aliases.conf in non-admin mode

> While that answer is correct, the better answer would be for the > Project to modify engine and installer to be Windows Vista+ > compliant and have all configuration files stored in All > Users\Application Data\Firebird and not in Programs Files\Firebird I just wanted to suggest that

Re: [firebird-support] FW: Scale-ability problems (PHP + firebird)

ibase_pconnect uses the same function as ibase_connect internally (the only diferrence is that is reusing connections) So I recommend to start with it http://php.net/manual/en/function.ibase-pconnect.php http://php.net/manual/en/function.ibase-pconnect.php

Re: [firebird-support] SQL Optimation best way

>A.field1 and field2 are the intern project number, b.fielda and b.fieldb are the extern ordernumber year and number. >Sum(A.field3) where a.field1 = condition1 and a.field2 = condition2 >In the same statement I would include >Sum(b.fieldc) where b.fielda = a.field4 and b.fieldb = a.field5

[firebird-support] FW: Scale-ability problems (PHP + firebird)

Hi Rudi, we have a PHP & Firebird environment too. To Reduce the overhead problems we use some caching techniques. So the amount of connections for a new site request shrinks dramatically. On the other side we're trying to reduce the amount by rewriting / optimizing some core queries. The