Nick Upson skriver:
I would expect the disk to be the bottleneck and not the CPU, in which case your suggestion might cause disk thrashing (disk head seeking back and forth), which would significantly reduce performance of this operation, and in any case you would gain nothing or very little by using multiple CPU:s.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 guess different data and hardware may give vastly different results. Perhaps the feature should be optional, in case it's implemented.
Kjell -- ------------------------------ Kjell Rilbe DataDIA AB E-post: kjell.ri...@datadia.se Telefon: 08-761 06 55 Mobil: 0733-44 24 64
<<attachment: kjell_rilbe.vcf>>
------------------------------------------------------------------------------ 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
