<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=Windows-1252">
</head>
<body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; color: rgb(0, 0, 0); font-size: 14px; font-family: Calibri, sans-serif;">
<div>Hello,</div>
<div><br>
</div>
<div>At the University of Denver, we have (as of about a month ago, when this particular backup of our database was run):</div>
<div><br>
</div>
<div>3,853 accessions</div>
<div>7,178 digital objects</div>
<div>833 resources (with a little over 125,000 archival objects attached)</div>
<div><br>
</div>
<div>This gives us a total database size of about 621.3 MB, and a Solr index of 1.8 GB. We’re by now a little bit higher than all of this, but not much. I’d also be interested to hear about others’ scales, since I don’t know how representative we are.</div>
<div><br>
</div>
<div>I would also echo what Mark said; all of this is based on the test instance of ArchivesSpace that I’ve been running on my laptop for a little over a year, so it’s pretty easy to play around with different system settings to see what works best. -k</div>
<div><br>
</div>
<div><br>
</div>
<span id="OLK_SRC_BODY_SECTION">
<div style="font-family:Calibri; font-size:11pt; text-align:left; color:black; BORDER-BOTTOM: medium none; BORDER-LEFT: medium none; PADDING-BOTTOM: 0in; PADDING-LEFT: 0in; PADDING-RIGHT: 0in; BORDER-TOP: #b5c4df 1pt solid; BORDER-RIGHT: medium none; PADDING-TOP: 3pt">
<span style="font-weight:bold">From: </span><<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org">archivesspace_users_group-bounces@lyralists.lyrasis.org</a>> on behalf of "Custer, Mark" <<a href="mailto:mark.custer@yale.edu">mark.custer@yale.edu</a>><br>
<span style="font-weight:bold">Reply-To: </span>Archivesspace Group <<a href="mailto:archivesspace_users_group@lyralists.lyrasis.org">archivesspace_users_group@lyralists.lyrasis.org</a>><br>
<span style="font-weight:bold">Date: </span>Tuesday, June 23, 2015 at 6:33 PM<br>
<span style="font-weight:bold">To: </span>Archivesspace Group <<a href="mailto:archivesspace_users_group@lyralists.lyrasis.org">archivesspace_users_group@lyralists.lyrasis.org</a>><br>
<span style="font-weight:bold">Subject: </span>Re: [Archivesspace_Users_Group] Size of Database<br>
</div>
<div><br>
</div>
<div dir="ltr"><style>
<!--
@font-face
{font-family:Wingdings}
@font-face
{font-family:"Cambria Math"}
@font-face
{font-family:Calibri}
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman",serif}
a:link, span.MsoHyperlink
{color:#0563C1;
text-decoration:underline}
a:visited, span.MsoHyperlinkFollowed
{color:#954F72;
text-decoration:underline}
p.emailquote, li.emailquote, div.emailquote
{margin-right:0in;
margin-left:1.0pt;
border:none;
padding:0in;
font-size:12.0pt;
font-family:"Times New Roman",serif}
span.EmailStyle18
{font-family:"Calibri",sans-serif;
color:#1F497D}
span.SpellE
{}
.MsoChpDefault
{font-size:10.0pt}
@page WordSection1
{margin:1.0in 1.0in 1.0in 1.0in}
div.WordSection1
{}
-->
</style><style type="text/css" id="owaParaStyle"></style>
<div lang="EN-US" link="#0563C1" vlink="#954F72" style="" fpstyle="1" ocsi="0">
<div style="direction: ltr;font-family: Tahoma;color: #000000;font-size: 10pt;">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(31, 73, 125);">Susan,</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(31, 73, 125);"> </span></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(31, 73, 125);">I don’t know if there are guidelines out there yet about all of the technical resources that institutions will need for ArchivesSpace, but we’re trying
to figure that out right now, as well, and then have our IT folks document that information (not so much to plan for the size of the database, which isn’t terribly large, but to make sure that we’re allotting enough RAM, etc., and that we have everything optimized).<span style="">
</span>All of which is to say that hopefully in a week or so we will have more information to share about what works best at our scale!</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(31, 73, 125);"> </span></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(31, 73, 125);">As for what exactly our scale is, right now our ArchivesSpace database is about 3.5 GB.
<span style=""> </span>We combined a few AT databases into one, though, so I wouldn’t assume that most institutions would have more than 1 GB of data in their database, if that (but I could be way off base with that assumption).<span style=""> In any event,</span> here
are a few stats from our ArchivesSpace database to give you a slightly better sense about its contents:</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(31, 73, 125);"> </span></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(31, 73, 125);">Accessions:<span style="">
</span>21,106</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(31, 73, 125);">Resources:<span style="">
</span>5,279</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(31, 73, 125);">Archival Components (subordinate levels of <span class="SpellE">desc</span>., not counting the resource records):<span style="">
</span>2,097,805 (and at some point, we might not want so many records in the same table!
</span><span style="font-size:11.0pt; font-family:Wingdings; color:#1F497D"><span style="">J</span></span><span style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(31, 73, 125);">)</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(31, 73, 125);"> </span></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(31, 73, 125);">But that’s just the size of the MySQL database.<span style="">
</span>There’s also the size of the SOLR index to consider, which can be substantially larger. I’ve got one on my desktop right now, for instance, where the SOLR directories take up about 18 GB -- the MySQL database is the same size, in that case.</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(31, 73, 125);"> </span></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(31, 73, 125);">As I mentioned, though, hopefully we'll have more information to share in the near future regarding the exact details of our setup (including details
about the webserver, etc.). In the meantime, I'd love to hear more about what you mean by significant data, as well as learn more about the different ASpace database sizes already out there in production.</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(31, 73, 125);"><br>
</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(31, 73, 125);">All my best,</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(31, 73, 125);"> </span></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(31, 73, 125);">Mark</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(31, 73, 125);"> </span></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(31, 73, 125);"><br>
</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(31, 73, 125);">P.S.<span style="">
</span>one nice thing about ArchivesSpace is that it’s pretty easy to just set up everything as a test on a local machine.<span style="">
</span>After you do that (or, better yet, get someone in IT to do that so that they can see for themselves), you can then import as much data into your test application that you want, and that should give you a much better estimate regarding your database size
and SOLR index once it’s up on a server, as well as the types of resources that you might need. </span></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(31, 73, 125);"> </span></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(31, 73, 125);"> </span></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(31, 73, 125);"> </span></p>
<div>
<div style="border:none; border-top:solid #E1E1E1 1.0pt; padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><a name="_MailOriginal"><b><span style="font-size: 11pt; font-family: Calibri, sans-serif;">From:</span></b></a><span style=""><span style="font-size: 11pt; font-family: Calibri, sans-serif;">
<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org">archivesspace_users_group-bounces@lyralists.lyrasis.org</a> [<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org">mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org</a>]
<b>On Behalf Of </b>Kerr, Susan<br>
<b>Sent:</b> Monday, June 22, 2015 3:17 PM<br>
<b>To:</b> <a href="mailto:archivesspace_users_group@lyralists.lyrasis.org">archivesspace_users_group@lyralists.lyrasis.org</a><br>
<b>Subject:</b> [Archivesspace_Users_Group] Size of Database</span></span></p>
</div>
</div>
<p class="MsoNormal"><span style=""> </span></p>
<div>
<p class="MsoNormal"><span style=""><span style="font-size: 11pt; font-family: Calibri, sans-serif;">I have been asked how much space the ArchivesSpace database will require. What has been the experience of those with significant data.</span></span></p>
</div>
<div>
<p class="MsoNormal"><span style=""><span style="font-size: 11pt; font-family: Calibri, sans-serif;"> </span></span></p>
</div>
<div>
<p class="MsoNormal"><span style=""><span style="font-size: 11pt; font-family: Calibri, sans-serif;">Thanks,</span></span></p>
</div>
<div>
<p class="MsoNormal"><span style=""><span style="font-size: 11pt; font-family: Calibri, sans-serif;">Susan</span></span></p>
</div>
<div>
<p class="MsoNormal"><span style=""><span style="font-size: 7.5pt; font-family: Calibri, sans-serif;">------------------------------------</span></span><span style=""><span style="font-size: 11pt; font-family: Calibri, sans-serif;"><br>
</span></span><span style=""><span style="font-size: 7.5pt; font-family: Arial, sans-serif;">Susan Kerr</span></span><span style=""><span style="font-size: 11pt; font-family: Calibri, sans-serif;"><br>
</span></span><span style=""><span style="font-size: 7.5pt; font-family: Arial, sans-serif;">Systems Librarian</span></span><span style=""><span style="font-size: 11pt; font-family: Calibri, sans-serif;"><br>
</span></span><span style=""><span style="font-size: 7.5pt; font-family: Arial, sans-serif;">704-894-2424, 704-894-2625 (fax)</span></span><span style=""><span style="font-size: 11pt; font-family: Calibri, sans-serif;"><br>
</span></span><span style=""></span><a href="mailto:sukerr@davidson.edu" target="_blank"><span style=""><span style="font-size: 7.5pt; font-family: Arial, sans-serif;">sukerr@davidson.edu</span></span><span style=""></span></a><span style=""><span style="font-size: 11pt; font-family: Calibri, sans-serif;"></span></span></p>
</div>
<div>
<p class="MsoNormal"><span style=""><span style="font-size: 11pt; font-family: Calibri, sans-serif;"> </span></span></p>
</div>
<div>
<p class="MsoNormal"><span style=""><span style="font-size: 7.5pt; font-family: Arial, sans-serif;">DAVIDSON COLLEGE LIBRARY</span></span><span style=""><span style="font-size: 11pt; font-family: Calibri, sans-serif;"></span></span></p>
</div>
<div>
<p class="MsoNormal"><span style=""><span style="font-size: 7.5pt; font-family: Arial, sans-serif;">209 RIDGE RD</span></span><span style=""><span style="font-size: 11pt; font-family: Calibri, sans-serif;"></span></span></p>
</div>
<div>
<p class="MsoNormal"><span style=""><span style="font-size: 7.5pt; font-family: Arial, sans-serif;">BOX 7200</span></span><span style=""><span style="font-size: 11pt; font-family: Calibri, sans-serif;"></span></span></p>
</div>
<div>
<p class="MsoNormal"><span style=""><span style="font-size: 7.5pt; font-family: Arial, sans-serif;">DAVIDSON, NC 28035-7200</span></span><span style=""><span style="font-size: 11pt; font-family: Calibri, sans-serif;"></span></span></p>
</div>
<div>
<p class="MsoNormal"><span style=""><span style="font-size: 7.5pt; font-family: Arial, sans-serif;"> </span></span><span style=""><span style="font-size: 11pt; font-family: Calibri, sans-serif;"></span></span></p>
</div>
<div>
<p class="MsoNormal"><span style=""><span style="font-size: 11pt; font-family: Calibri, sans-serif;"> </span></span></p>
</div>
<div>
<p class="MsoNormal"><span style=""><span style="font-size: 11pt; font-family: Calibri, sans-serif;"> </span></span></p>
</div>
<div>
<p class="MsoNormal"><span style=""><span style="font-size: 11pt; font-family: Calibri, sans-serif;"> </span></span><span style="font-size: 11pt; font-family: Calibri, sans-serif;"></span></p>
</div>
</div>
</div>
</div>
</div>
</span>
</body>
</html>