Re: [firebird-support] How I can speed up this query

2017-10-11 Thread setysvar setys...@gmail.com [firebird-support]
11.10.2017 19:43, Luigi Siciliano wrote: > Hallo, > > I have this query > > SELECT > ID, > DENOMINAZIONE, > SCADENZA, > PARTITA, > NUMERO_DOCUMENTO, > DATA_DOCUMENTO, > IMPORTO, > IMPORTO - PAGATO AS RESIDUO, > PAGATO, > PAGAMENTO, > SALDARE > from > ( >

RE: [firebird-support] Converting to firebird 3

2017-10-11 Thread 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support]
> We have an application with roughly 20 000 lines of code and have been using > firebird 2.5 since the start. We do experience performance problems with > 30+ client connections and are thinking of moving to firebird 3. You haven't provided any real details. Are you using SuperServer or

[firebird-support] Converting to firebird 3

2017-10-11 Thread 'Gian Uys' gian...@gmail.com [firebird-support]
Hi We have an application with roughly 20 000 lines of code and have been using firebird 2.5 since the start. We do experience performance problems with 30+ client connections and are thinking of moving to firebird 3. Is firebird 3 drastically going to improve performance and how immense

[firebird-support] How I can speed up this query

2017-10-11 Thread Luigi Siciliano luigi...@tiscalinet.it [firebird-support]
Hallo, I have this query SELECT   ID,   DENOMINAZIONE,   SCADENZA,   PARTITA,   NUMERO_DOCUMENTO,   DATA_DOCUMENTO,   IMPORTO,   IMPORTO - PAGATO AS RESIDUO,   PAGATO,   PAGAMENTO,   SALDARE from ( SELECT   C.ID,   C.DENOMINAZIONE,   PNS.SCADENZA,   PNS.PARTITA,