Christopher (& Jesse), Would the calculation not be rounded up to 1 KB, not 1MB, per record? Thus, each set of 1,000 records (1K each) would equal 1MB? 13,000 bib records would need a minimum of 13MB of storage. Is that right? The next question is, "How many keywords and other index pointers does KOHA have taking additional space per record?" Authority records also take space if you use them. In a non-KOHA, commercial program, I have as many authority records as I do bib records. Fran __________________________ Fran Weimer Dallas, TX 75236 -- Christopher Brown-Syed <cbrownsyed@cogeco.ca> wrote: Return-Path: <koha-bounces@lists.katipo.co.nz> Received: from mx05.vgs.untd.com (mx05.vgs.untd.com [10.181.44.35]) by maildeliver07.vgs.untd.com with SMTP id AABD5YL4BAB6TDK2 for <franweimer@juno.com> (sender <koha-bounces@lists.katipo.co.nz>); Tue, 19 Feb 2008 11:17:21 -0800 (PST) Received: from daddy.katipo.co.nz (daddy.katipo.co.nz [202.50.109.200]) by mx05.vgs.untd.com with SMTP id AABD5YL4AAVQEJQS (sender <koha-bounces@lists.katipo.co.nz>); Tue, 19 Feb 2008 11:17:20 -0800 (PST) Received: from localhost (localhost.localdomain [127.0.0.1]) by daddy.katipo.co.nz (Postfix) with ESMTP id 8224811E5D; Wed, 20 Feb 2008 08:17:18 +1300 (NZDT) Received: from daddy.katipo.co.nz ([127.0.0.1]) by localhost (daddy [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 25882-02; Wed, 20 Feb 2008 08:17:17 +1300 (NZDT) Received: from daddy.katipo.co.nz (localhost.localdomain [127.0.0.1]) by daddy.katipo.co.nz (Postfix) with ESMTP; Wed, 20 Feb 2008 08:17:17 +1300 (NZDT) Received: from localhost (localhost.localdomain [127.0.0.1]) by daddy.katipo.co.nz (Postfix) with ESMTP id CE6BD11E88 for <koha@lists.katipo.co.nz>; Wed, 20 Feb 2008 06:15:29 +1300 (NZDT) Received: from daddy.katipo.co.nz ([127.0.0.1]) by localhost (daddy [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 20925-09 for <koha@lists.katipo.co.nz>; Wed, 20 Feb 2008 06:15:18 +1300 (NZDT) X-Greylist: delayed 1391 seconds by postgrey-1.21 at daddy; Wed, 20 Feb 2008 06:15:18 NZDT Received: from fep7.cogeco.net (smtp2.cogeco.ca [216.221.81.29]) by daddy.katipo.co.nz (Postfix) with ESMTP for <koha@lists.katipo.co.nz>; Wed, 20 Feb 2008 06:15:18 +1300 (NZDT) Received: from [192.168.0.3] (d141-150-5.home.cgocable.net [24.141.150.5]) by fep7.cogeco.net (Postfix) with ESMTP id 6D2502E06; Tue, 19 Feb 2008 11:51:54 -0500 (EST) Message-ID: <47BB0922.5050808@cogeco.ca> Date: Tue, 19 Feb 2008 11:51:46 -0500 From: Christopher Brown-Syed <cbrownsyed@cogeco.ca> User-Agent: Mozilla Thunderbird 1.0.7 (Macintosh/20050923) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Jesse <pianohacker@gmail.com> Subject: Re: [Koha] Disk space requirement for Web Server References: <003201c872a7$d2cb8fc0$7862af40$@org.au> <ab4467480802190754x53ad9a94of5f7785762ac50af@mail.gmail.com> In-Reply-To: <ab4467480802190754x53ad9a94of5f7785762ac50af@mail.gmail.com> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at example.com X-Mailman-Approved-At: Wed, 20 Feb 2008 08:13:48 +1300 Cc: Koha Mailing List <koha@lists.katipo.co.nz> X-BeenThere: koha@lists.katipo.co.nz X-Mailman-Version: 2.1.5 Precedence: list List-Id: Discussion list for the Koha Library system <koha.lists.katipo.co.nz> List-Unsubscribe: <http://lists.katipo.co.nz/mailman/listinfo/koha>, <mailto:koha-request@lists.katipo.co.nz?subject=unsubscribe> List-Archive: <http://lists.katipo.co.nz/pipermail/koha> List-Post: <mailto:koha@lists.katipo.co.nz> List-Help: <mailto:koha-request@lists.katipo.co.nz?subject=help> List-Subscribe: <http://lists.katipo.co.nz/mailman/listinfo/koha>, <mailto:koha-request@lists.katipo.co.nz?subject=subscribe> Sender: koha-bounces@lists.katipo.co.nz Errors-To: koha-bounces@lists.katipo.co.nz X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at example.com X-ContentStamp: 6:3:2785513255 X-MAIL-INFO:38250d550d19fcec7819b178792da888484d89894559f85d91c5c529c1090c9ce53c8c4d9c0d6c15cc81ccec7945e919cc08 X-UNTD-Peer-Info: 202.50.109.200|daddy.katipo.co.nz|daddy.katipo.co.nz|koha-bounces@lists.katipo.co.nz X-UNTD-UBE:-1 Jesse wrote:
the MySQL database is 184 MiB for our catalog of roughly 13,000 books and 2,000 patrons.
Back in the pre-history of library automation (the 1980s), when space was tight and disks expensive, we used to estimate the size of a bibliographic database at 768 bytes per MARC record. I suspect that rounding up to 1 MB/ bib record is probably still a good guess. That's for the generic "title level" description, not including information about all the copies of a title. Don't forget to allow for annual growth, and extra room for abstracts or lengthy notes (e.g. for archival items or rare books), and for local holdings information, especially if you record journal issues. Chris Brown-Syed _______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha _____________________________________________________________ Click for free info on discount teaching degrees programs. http://thirdpartyoffers.juno.com/TGL2121/fc/Ioyw6i3njBiMFblJrl0PPMctdwEABfLm...