Hi Rob, We've been hit _hard_ by it too. At this point, the only real workaround is to change your architecture to use the file streaming API. One suggestion is to throw your data sequentially into a file and create a header that points to where the individual record data is in the file. You can then create a wrapper to let it access it like the DB API. However, that really only works well if your data is read only. If you have to do a lot of inserting and resizing of data, then you're kind of stuck.
Sorry to bear bad news, -Jon ------------------------------------------- Jonathan Hays Palm OS Certified Developer http://hazelware.luggle.com ------------------------------------------- -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Rob Sent: Friday, February 11, 2005 6:29 AM To: Palm Developer Forum Subject: NVFS small record bug Hi folks, I've just realised that the NVFS issue where records in a db are expanded to at least 512bytes is massive for my application (Initiate). On my device, the lookup table where I kept a list of all the contacts, memos, applications, etc to launch expands from 40k to 400k. Users with bigger databases are seeing 2-4meg sucked up. Does anyone have any ideas to workaround this - or any news on whether it is going to be fixed in a ROM update? Cheers, Rob -- For information on using the Palm Developer Forums, or to unsubscribe, please see http://www.palmos.com/dev/support/forums/ -- For information on using the Palm Developer Forums, or to unsubscribe, please see http://www.palmos.com/dev/support/forums/
