Which is the limit on the number of records in a palm database? I've seen the function "DmNumRecords" is defined as UInt16 So I suppose yhe limit is 32768. Is it possible to have databases with more records than this limit??
Actually, I think the limit is 16K records, as the DB index has to be stored in a single 64K chunk, and there's a 4-byte pointer per index.
Generally, people pack multiple records into a single database entry. Look at techniques like B-Trees to see efficient ways of handling this while still keeping a sorting order. This also helps enormously at HotSync time, as the time needed to copy a database grows exponentially by the number of records in the DB on some OS versions.
--
Ben Combee <[EMAIL PROTECTED]>
CodeWarrior for Palm OS technical lead
Palm OS programming help @ www.palmoswerks.com
-- For information on using the Palm Developer Forums, or to unsubscribe, please see http://www.palmos.com/dev/support/forums/
