<[EMAIL PROTECTED]> wrote in message news:<[EMAIL PROTECTED]>... > The app is an aid to our Unix based Information Management System that > tracks -among > other things- product inventory in stores. The requirements are to be able > to store up to > 100 bytes of information per record at up to 65,000 records. > > What I'm currently doing is packing as many of our records (null delimited > and sorted alpha- > numerically) into each Palm record up to the 64k limit (give or take) and
Try leaving more space in each Palm Record. This will allow the records to be added or deleted without affecting every other Palm Record. If I'm understanding right, for 100 bytes per record divided by 65k, you can fit about 655 records into each Palm Record. Try just putting 200 or 300 records (or more if you're not doing many adds) into each Palm record and use more Palm Records. > creating an index > record as the the very last palm record which contains the very first > product number stored > in each previous palm record. When searching, I refer to this index record > to know what Palm record to search in. If you can, try to avoid the index. If you keep all the records sorted, you should be able to do a binary search on your Palm records to find the Palm record that has the Product Number you're looking for, then find the Product Number within the Palm record. > This is all fine and dandy so far, but now in terms of syncing, this > database structure is limited > in that if a product is deleted or added, chances are that every palm > record will need to be re-syncd. > With this in mind, those above me are considering on lowering our max of > 65,000 to 40,000 if You should be able to run way more than 40k records this way as you can have around 32k Palm records (or is it 64k? might depend on OS). Multiply that by however many records you decide to put in each Palm Record and you should be able to run well over a million records and be limited only by your desired sync times. Matt -- For information on using the Palm Developer Forums, or to unsubscribe, please see http://www.palmos.com/dev/support/forums/
