Hi folks,
I have a performance issue with the large-scale system. I know that this discussion depends on resources, so please assume sufficient resources are available.
Let's think about a single read-only transaction performance by just 'run <file name>'. Assuming that elapsed time is 5 sec and CPU time is 1 sec.
Then I tried processing this query by concurrent 2 users by phantom, but each user of elapsed and CPU time was very much worse than single. Roughly, it's 10 times worse.
In reality, Is it impossible to get a benefit from parallel processing?
---- Sample basic program.
cnt = 300000
open "STOCK" to fp else abort
startTime = Time()
startTimeCpu = System(9)
for i=1 to cnt
read rec from fp,"101" else abort
next i
endTime = Time()
endTimeCpu = System(9)
print "elapse : ":(endTime - startTime)
print "elapse(cpu) : ":(endTimeCpu - startTimeCpu)/1000
end
-------------------------------------
------------------------------
Yukio Kozuka
Simount Corp
Bunkyo-ku JP
------------------------------