Nick, > > 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
As others have said, the cost of building an index is primarily the cost of reading the data, so building indexes in parallel on separate threads is unlikely to help. Building indexes incrementally as the data is stored (as someone else suggested) will be slow and build less dense indexes than the current method which requires sorting the data. What might help, but would require engine support is the ability to build two indexes on the same data with a single read of a table. Cheers, Ann ------------------------------------------------------------------------------ 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
