Backup restore is slow in FB3 when the database contains many small tables with indices ---------------------------------------------------------------------------------------
Key: CORE-5101 URL: http://tracker.firebirdsql.org/browse/CORE-5101 Project: Firebird Core Issue Type: Bug Components: Engine, GBAK Affects Versions: 3.0 RC2 Environment: Windows Reporter: michalk1 Priority: Minor Attachments: Fb25Gbk.zip, Fb30Gbk.zip Let's have a database with 1000 simple empty tables CREATE TABLE TABn (ID INTEGER PRIMARY KEY) The gbk restore time (without verbose switch) of the database is 15 seconds in FB2.5 vs 2 minutes in FB3 RC1. When run in verbose mode, it shows that FB3 gbak spends too much time in "activating and creating deferred index" lines phase. -- 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 ------------------------------------------------------------------------------ Site24x7 APM Insight: Get Deep Visibility into Application Performance APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month Monitor end-to-end web transactions and take corrective actions now Troubleshoot faster and improve end-user experience. Signup Now! http://pubads.g.doubleclick.net/gampad/clk?id=267308311&iu=/4140 Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel