Improve GBAK restore performance -------------------------------- Key: CORE-3433 URL: http://tracker.firebirdsql.org/browse/CORE-3433 Project: Firebird Core Issue Type: Improvement Components: GBAK Reporter: Adriano dos Santos Fernandes
There is a simple change which makes it much faster, tested with Linux 2.5 embedded restore: Two databases, with two different tables filled with 2,000,000 records: create table t1 (n1 integer); create table t10 (n1 integer, n2 integer, n3 integer, ..., n10 integer); ---------------------- Restore timings: T1: 14.5s T10: 20.5s Improved gbak timings: T1: 9.7s T10: 14.7s ---------------------- GBAK builts a BLR in the following way: blr_receive blr_store ... Then calls isc_start_and_send N (records) time. My change creates this BLR: blr_loop blr_receive blr_store ... Calls isc_start_and_send first time then N-1 isc_send. -- 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 ------------------------------------------------------------------------------ Xperia(TM) PLAY It's a major breakthrough. An authentic gaming smartphone on the nation's most reliable network. And it wants your games. http://p.sf.net/sfu/verizon-sfdev Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel