EPICS Controls Argonne National Laboratory

Experimental Physics and
Industrial Control System

1994  1995  1996  1997  1998  1999  2000  2001  2002  2003  2004  2005  2006  2007  2008  2009  2010  2011  2012  2013  2014  <20152016  2017  2018  2019  2020  2021  2022  2023  2024  Index 1994  1995  1996  1997  1998  1999  2000  2001  2002  2003  2004  2005  2006  2007  2008  2009  2010  2011  2012  2013  2014  <20152016  2017  2018  2019  2020  2021  2022  2023  2024 
<== Date ==> <== Thread ==>

Subject: Expected database load times
From: Klemen Vodopivec <[email protected]>
To: "[email protected]" <[email protected]>
Date: Fri, 15 May 2015 19:11:06 +0200 (CEST)
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

Replies:
Re: Expected database load times Andrew Johnson
RE: Expected database load times Dalesio, Leo

Navigate by Date:
Prev: RE: scalcout fails to write to bo Mooney, Tim M.
Next: Re: Expected database load times Andrew Johnson
Index: 1994  1995  1996  1997  1998  1999  2000  2001  2002  2003  2004  2005  2006  2007  2008  2009  2010  2011  2012  2013  2014  <20152016  2017  2018  2019  2020  2021  2022  2023  2024 
Navigate by Thread:
Prev: RE: scalcout fails to write to bo Mooney, Tim M.
Next: Re: Expected database load times Andrew Johnson
Index: 1994  1995  1996  1997  1998  1999  2000  2001  2002  2003  2004  2005  2006  2007  2008  2009  2010  2011  2012  2013  2014  <20152016  2017  2018  2019  2020  2021  2022  2023  2024 
ANJ, 16 Dec 2015 Valid HTML 4.01! · Home · News · About · Base · Modules · Extensions · Distributions · Download ·
· Search · EPICS V4 · IRMIS · Talk · Bugs · Documents · Links · Licensing ·