catch.saravana
Member
Hi All,
I am facing performance issues with parallel load with inline index build.
Let's take a scenario, I was able to run 4 loads with inline index build in < 6 minutes when I ran it one by one (without proserve just proutil). The same set of 4 loads are taking around 23 minutes to complete when ran in parallel from 4 terminals (with proserve). What do you think the reason could be?
proserve test.db -spin 5000 -bibufs 5 -n 70 -Mn 10 -Mpb 4 -Ma 10 -Mi 3 -minport 10206 -maxport 10270 -Mm 32600 -mmax 65534 -baseindex 1 -indexrangesize 4000 -basetable 1 -tablerangesize 4000 -B 1250000 -i -pwsdelay 100 -pwscan 4166 -pwwmax 4166
proutil test.db -C load /dumplocal/t1.bd build indexes -T /tmpForidx -spin 5000 -i -B 312500 -TB 64 -TM 32 -TMB 64 -SG 64
proutil test.db -C load /dumplocal/t2.bd build indexes -T /tmpForidx -spin 5000 -i -B 312500 -TB 64 -TM 32 -TMB 64 -SG 64
proutil test.db -C load /dumplocal/t3.bd build indexes -T /tmpForidx -spin 5000 -i -B 312500 -TB 64 -TM 32 -TMB 64 -SG 64
proutil test.db -C load /dumplocal/t4.bd build indexes -T /tmpForidx -spin 5000 -i -B 312500 -TB 64 -TM 32 -TMB 64 -SG 64
Do we have to add any other parameter or tweak some values to resolve the performance issue?
Regards,
Saravanakumar B
I am facing performance issues with parallel load with inline index build.
Let's take a scenario, I was able to run 4 loads with inline index build in < 6 minutes when I ran it one by one (without proserve just proutil). The same set of 4 loads are taking around 23 minutes to complete when ran in parallel from 4 terminals (with proserve). What do you think the reason could be?
proserve test.db -spin 5000 -bibufs 5 -n 70 -Mn 10 -Mpb 4 -Ma 10 -Mi 3 -minport 10206 -maxport 10270 -Mm 32600 -mmax 65534 -baseindex 1 -indexrangesize 4000 -basetable 1 -tablerangesize 4000 -B 1250000 -i -pwsdelay 100 -pwscan 4166 -pwwmax 4166
proutil test.db -C load /dumplocal/t1.bd build indexes -T /tmpForidx -spin 5000 -i -B 312500 -TB 64 -TM 32 -TMB 64 -SG 64
proutil test.db -C load /dumplocal/t2.bd build indexes -T /tmpForidx -spin 5000 -i -B 312500 -TB 64 -TM 32 -TMB 64 -SG 64
proutil test.db -C load /dumplocal/t3.bd build indexes -T /tmpForidx -spin 5000 -i -B 312500 -TB 64 -TM 32 -TMB 64 -SG 64
proutil test.db -C load /dumplocal/t4.bd build indexes -T /tmpForidx -spin 5000 -i -B 312500 -TB 64 -TM 32 -TMB 64 -SG 64
Do we have to add any other parameter or tweak some values to resolve the performance issue?
Regards,
Saravanakumar B