[Koha] Disk space requirement for Web Server

[franweimer at juno.com]

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 at cogeco.ca> wrote:
Return-Path: <koha-bounces at 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 at juno.com> (sender <koha-bounces at 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 at 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 at 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 at 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 at 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 at cogeco.ca>
Date: Tue, 19 Feb 2008 11:51:46 -0500
From: Christopher Brown-Syed <cbrownsyed at cogeco.ca>
User-Agent: Mozilla Thunderbird 1.0.7 (Macintosh/20050923)
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: Jesse <pianohacker at gmail.com>
Subject: Re: [Koha] Disk space requirement for Web Server
References: <003201c872a7$d2cb8fc0$7862af40$@org.au>
	<ab4467480802190754x53ad9a94of5f7785762ac50af at mail.gmail.com>
In-Reply-To: <ab4467480802190754x53ad9a94of5f7785762ac50af at 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 at lists.katipo.co.nz>
X-BeenThere: koha at 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 at lists.katipo.co.nz?subject=unsubscribe>
List-Archive: <http://lists.katipo.co.nz/pipermail/koha>
List-Post: <mailto:koha at lists.katipo.co.nz>
List-Help: <mailto:koha-request at lists.katipo.co.nz?subject=help>
List-Subscribe: <http://lists.katipo.co.nz/mailman/listinfo/koha>,
	<mailto:koha-request at lists.katipo.co.nz?subject=subscribe>
Sender: koha-bounces at lists.katipo.co.nz
Errors-To: koha-bounces at 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 at 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 at 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/Ioyw6i3njBiMFblJrl0PPMctdwEABfLmqEVlYtT06idjLRbH3QUv92/