At 04:15 AM 5/21/2006, you wrote:
Subject: Maximum Size of PDB
From: Regis melo <[EMAIL PROTECTED]>
Date: Sat, 20 May 2006 17:36:08 -0300
PDB has a maximum size or number of record limitations? Can I store
very huge pdbs on my card? What is the limitations of PDB?
Régis
Discussed many times...check the archives for detail.
The quick summary is as follows
Maximum size of PDB is 64000*64000
However there are specific performance issues you
hit with tens of thousands of PDB records, so
large numbers of small PDB records is poor design.
If you have tens of thousands of records, then
best solution is to place multiple physical
records into each PDB record and then have a
software layer that handles record
block/unblock. In other words, view PDB records
as variable length blocks, not really records.
For example, I use this technique and have a
library customer who has databases with over
200,000 records, but with less than 1000 PDB blocks (== PDB records).
As protection against possible weird issues with
signed and unsigned 16 bit integers, I also keep
my PDB record size below 32500.
Roger Stringer
Marietta Systems, Inc. (www.rf-tp.com)
--
For information on using the PalmSource Developer Forums, or to unsubscribe,
please see http://www.palmos.com/dev/support/forums/
