I've just started with QV 10 and read about the new feature of multithreading during load. But I think I didn't understand this feature right. Is there a document that describes the new feature in detail? Maybe one of you guys can help me.
What in fact was optimized with QV 10, are all the select or the load statements in the script processed in several threads?
The feature takes each load statement in sequence (the entire script is not run in parallel). Operations of transformation, calculation that can be executed in parallel within a load statement, are spread over the available threads. Certain operations within a load statement such as inter-record functions, prevent the particular load statement from being executed across more than 1 thread.
There is no requirement to upgrade or modify your script to see how V10 performance compares against V9.
Yes the load and select statements are executed in the sequence that they are written. The calculation part of the statement will be executed in parallel if it has no preceding reference. The actual fetch of data will be bound by the ODBC or OLEDB connection