R
Rob Debbage
Guest
Hello Valeriy, Re. your Pro2-related questions: 1. How long time needed for load 100 000 records into your Oracle database? I do not believe that we can say for sure - if I gave you a number then it would be specific to my system. Performance can vary system to system depending on the capabilities of the machines involved, the network, etc. 2. If there is some special parameters for connect to Progress Data Server Schema Holder to improve performance (-DSRV)? Which parameters did you use? If there is a parameter for transaction size? No. A bulk load will comprise of a series of SQL INSERT statements; each record is inserted individually. You can run multi-thread bulk loads, but there is currently no real way to impact performance in this area on the product side. 3. If there is some special parameters in the Properties of Pro2 to make commit not for each records but, for example, for each 1000 records? No. 4. Why Pro2 make commit for each record in the Bulk-Copy Process? It is the way that the underlying DataServer works. Please feel free to log an Idea on the Progress Community if you would like to see this behaviour change. I would recommend engaging Pro2 Services for further assistance. They can provide advice targeted to the specific environment. Kind regards, Rob
Continue reading...
Continue reading...