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
- References:
- Expected database load times Klemen Vodopivec
- Navigate by Date:
- Prev:
Re: "epicsMutex pthread_mutex_unlock failed" with pyepics/pcaspy Michael Davidsaver
- Next:
Fortran CA Client Interface chengmaosong
- Index:
1994
1995
1996
1997
1998
1999
2000
2001
2002
2003
2004
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014
<2015>
2016
2017
2018
2019
2020
2021
2022
2023
2024
- Navigate by Thread:
- Prev:
Re: Expected database load times Andrew Johnson
- Next:
Fortran CA Client Interface chengmaosong
- Index:
1994
1995
1996
1997
1998
1999
2000
2001
2002
2003
2004
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014
<2015>
2016
2017
2018
2019
2020
2021
2022
2023
2024
|