Differences

This shows you the differences between two versions of the page.

--- faq:dbsize [2013/04/01 18:40] – [Reorganising Databases] Colin Liebenrood
+++ faq:dbsize [2013/04/01 18:43] – [Size Limits] Colin Liebenrood
@@ Line 4: / Line 4: @@
 ==== Size Limits ====
 //What is the maximum size of a Pedigree database? //
 There are two limits, which apply individually to each record-type
 in a Pedigree Database (Person, Marriage, Source...). Firstly,
 the maximum number of records is 32767, including any records deleted
 in the current session.
 Secondly, the maximum size of the data file (Person.dat,
 Marriage.dat....) is 1Mb in a standard Pedigree database. Where
 this size is approached, then for PediTree, or Pedigree versions 2.6d
 or later, there are other options: a //large// database can be up
 to 3Mb; a //huge// database up to 4Mb (Pedigree version 2.6j or later). PediTree
 only has even larger options: //jumbo// up to 6Mb; //massive// up to 9Mb.
 These options allocate file-space in larger chunks: the
 standard database allocates in 16-byte chunks; //large// in 48-byte
 chunks; //huge// in 64-byte chunks. The consequence is that on
 average each record takes more space, so that changing to larger versions
 will usually increase the size of an existing file,
 before any new information is added. An article in the PUG //Newsletter//
 Vol.7 No.3 p.14 gives further details.
 Before deciding to move to a larger version, it may be
 worth reorganising the existing database to eliminate spare space,
 including that taken by any deleted records. If you are close to
 the size limit, but are no longer making substantial additions to
+your database, this may be sufficient.
-your datab
-ase, this may be sufficient.
 ==== Reorganising Databases ====