Experimental Physics and
Industrial Control System

"Dalesio, Leo" <[email protected]> · Sat, 16 May 2015 11:16:31 +0000

Hmmmm, 100,000 records in 30 seconds. That sounds pretty good.
What in the world are you doing with an IOC with 100K records?
What is the idle time once it is running? 

More files = slower, we have always seen that.
Are you loading only fields which are not the default values?
Have you profiled the code?
Did you try converting it to binary on the workstation ahead of time?

Please share your results when you are done.
Thanks,
Bob

________________________________________
From: [email protected] [[email protected]] on behalf of Klemen Vodopivec [[email protected]]
Sent: Friday, May 15, 2015 1:11 PM
To: [email protected]
Subject: Expected database load times

Dear all,

I'm interested in the time it takes to load database(s) with thousands of records. For about 100,000 records we're seeing IOC boot times in range 30s or more when loaded with dbLoadRecords(). Without related database the IOC boots instantly. Most records connect to asyn port. Disabling macro substitution doesn't seem to have much effect. When spread into several files with about the same amount of records one can observe gradually slowing down the time it takes to load one file.

What are others' experiencing? Is there anything to speed it up?

Not a big concern, though, since our IOCs are mostly running all times.

Thanks, Klemen

Experimental Physics and Industrial Control System

Experimental Physics and
Industrial Control System