Execution of multiple stored procedures in some case is slow ------------------------------------------------------------
Key: CORE-5782 URL: http://tracker.firebirdsql.org/browse/CORE-5782 Project: Firebird Core Issue Type: Bug Components: Engine Affects Versions: 3.0.3, 3.0.4 Reporter: Karol Bieniaszewski We are in point of migration of database from Interbase to Firebird and encountered slownes. Below query run slow ~1s. With same shema this query run instant on Interbase. We have analysed all procedures execution one by one and all looks fast with good plans. But as whole it is slow compared to Interbase. SELECT D.DYR_ID , D.DYR_NAZWA , D2.DYR_ID AS MA_DYR_UPR FROM DYREKCJA D LEFT JOIN Pracownik_dyr_akcja(49, 0, 'ARozrachunkiKsiegowane', '') D2 ON D2.DYR_ID = D.DYR_ID WHERE D.OBSZAR_ID = 1 AND D.DYR_ID <> 0 ORDER BY D.DYR_NAZWA COLLATE PXW_PLK ASC one point in comparision is that Firebird for above query use PLAN SORT (JOIN (D INDEX (FK_DYREKCJA__OBSZAR), D2 NATURAL)) but Interbase PLAN SORT (MERGE (SORT (D INDEX (RDB$FOREIGN323)),SORT ())) on Firebird there are 561598 fetches when on Interbase there is only 30199 fetches I have attached difference with stats and sample database to test -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel