V
Valeriy Bashkatov
Guest
Just about the need for a multithreading. Here is a small part of my experiments: $ time proutil largedb3 -C partitionmanage split table theTable composite initial OpenEdge Release 11.5.1 as of Tue Mar 31 19:00:25 EDT 2015 BEGIN: Split Operation For Table theTable (17384) Source Partition initial[0] Target Partition IntField-1[3] Target Partition IntField-2[4] Target Partition IntField-3[5] Index IntField has been identified as the scanning index (selected). A non-unique index has been selected as the useindex index. Additional locking is required with the use of this index IntField. Number of Records per Transaction (recs): 100 Do you want to continue (y/n)? y 1000000 records processed. (15165) 2000000 records processed. (15165) 3000000 records processed. (15165) 4000000 records processed. (15165) 5000000 records processed. (15165) 6000000 records processed. (15165) 7000000 records processed. (15165) 8000000 records processed. (15165) Target partition: IntField-1[3], records moved: 8184959. 9000000 records processed. (15165) 10000000 records processed. (15165) 11000000 records processed. (15165) 12000000 records processed. (15165) 13000000 records processed. (15165) 14000000 records processed. (15165) 15000000 records processed. (15165) 16000000 records processed. (15165) Target partition: IntField-2[4], records moved: 8183704. 17000000 records processed. (15165) 18000000 records processed. (15165) 19000000 records processed. (15165) 20000000 records processed. (15165) 21000000 records processed. (15165) 22000000 records processed. (15165) 23000000 records processed. (15165) 24000000 records processed. (15165) Target partition: IntField-3[5], records moved: 8181016. Source partition: initial[0], still contains records. Total records processed: 24549679. END: Split Operation For Table theTable[0] Split Operation finished successfully. (17359) real 1654m33.155s user 376m48.248s sys 16m30.662s
Continue reading...
Continue reading...