>> Hi, >> >> before putting this idea into the trackers I wanted to make sure its >> not totally crazy. >> >> When gbak finishes the actual data part of the restore it then creates >> all the indexes, could it do that in parallel based on the number of >> processors available. >> It seems daft that I have to wait for each index to be built, one at a >> time, when the server has several processors doing nothing >> > > I once tried to manually do this with FB 3 in multiple connections. I > found no benefit in my tests, but so far, feel free to try and report back.
I have seen better performance, especially during index creation, when restoring with a largish page buffers value, but this get set permantly, so one has to switch back the page buffers value after the database has been restored. Regards, Thomas ------------------------------------------------------------------------------ Virtualization & Cloud Management Using Capacity Planning Cloud computing makes use of virtualization - but cloud computing also focuses on allowing computing to be delivered as a service. http://www.accelacomm.com/jaw/sfnl/114/51521223/ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
