this is good to know! although many of the libraries will have 20,000 items we have more than that,

Subj: Re: [Koha] max. number of items in KOHA Date: 7/28/01 5:45:18 AM US Mountain Standard Time From: chris@katipo.co.nz (Chris Cormack) Sender: koha-admin@lists.katipo.co.nz To: koha@lists.katipo.co.nz

On Fri, Jul 27, 2001 at 05:01:44PM -0400, COURYHOUSE@aol.com said:

...

Was wondering what the max. number of items in koha are allowed, or how far has it been tested to date.

Hi Ed

Since all the data for koha is stored in a mysql database, the max number of items is pretty much the max that mysql can handle. Which quoting from the mysql FAQ is

"The maximum table size is limited by the MySQL version, the OS and in particular the filesystem. In most cases, this effectively comes out to: "The size of your hard drive." Many Linux systems impose a 2GB limit on files.

MySQL v. 3.23 in particular, can be compiled to enable large tables which are only limited by the filesystem (unless, of course, your drive is larger than 800 million terabytes.)"

But as to testing, at the moment we have 70734 biblio records and 85217 items. So we arent pushing the boundaries :-)

Chris -- Chris Cormack Programmer 025 500 789 Katipo Communications Ltd chris@katipo.co.nz www.katipo.co.nz _______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha