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, PNT.NUMERO_DOCUMENTO, PNT.DATA_DOCUMENTO, PNS.IMPORTO, COALESCE((SELECT SUM(PNC2.AVERE - PNC2.DARE) from PN_CORPO PNC2 WHERE PNC2.PARTITA = PNS.PARTITA AND PNC2.SCADENZA = PNS.SCADENZA AND PNC2.SCADENZA IS NOT NULL ), 0) AS PAGATO, 0.00 AS PAGAMENTO, '0' AS SALDARE from PN_SCADENZE PNS, PN_CORPO PNC, CLIENTI C, PN_TESTA PNT where PNS.PN_TESTA_ID = PNC.PN_TESTA_ID AND C.ID = PNC.CLIENTE_ID AND PNT.ID = PNS.PN_TESTA_ID ) From Statistics of Flamerobin: Prepare time: 0.014s Field #01: . Alias:ID Type:SMALLINT Field #02: . Alias:DENOMINAZIONE Type:STRING(60) Field #03: . Alias:SCADENZA Type:DATE Field #04: . Alias:PARTITA Type:INTEGER Field #05: . Alias:NUMERO_DOCUMENTO Type:STRING(20) Field #06: . Alias:DATA_DOCUMENTO Type:DATE Field #07: . Alias:IMPORTO Type:NUMERIC(18,4) Field #08: . Alias:RESIDUO Type:NUMERIC(18,4) Field #09: . Alias:PAGATO Type:NUMERIC(18,4) Field #10: . Alias:PAGAMENTO Type:NUMERIC(18,2) Field #11: . Alias:SALDARE Type:STRING(1) PLAN (PNC2 NATURAL) PLAN JOIN (PNC NATURAL, PNT INDEX (PN_TESTA_PK), C INDEX (PK_CLIENTI), PNS INDEX (PN_SCADENZE_FK)) Executing... Done. 4684158 fetches, 0 marks, 0 reads, 0 writes. 0 inserts, 0 updates, 0 deletes, 3011 index, 2313903 seq. Delta memory: 70560 bytes. Total execution time: 1.608s Script execution finished How I can speed up it? The time 1.608s if referred at only 300 rows fetched as defaults of flamerobin. In production I have 1157 rows affected (they grows rapidly) in near 6.20s. Thanks -- Luigi Siciliano -------------------------- ------------------------------------ ------------------------------------ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ ------------------------------------ Yahoo Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: [email protected] [email protected] <*> To unsubscribe from this group, send an email to: [email protected] <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
