Adrien,
>The thing that confuses me is that it seems you are advocating against
>the use of a logical record scheme.
By all means not. If you check the archives, you'll see I very much advocate
rolling your own logical record schemes. I have databases where I need to
support over 65000 (logical) records. Plus due to the Hot Sync bottleneck on
the physical record count, I'd do the same even if I needed only several
thousand records.
What I am saying is that I don't believe you can make this transparent to the
developer while maintaining compatibility with other things like conduits. It
really needs to be designed into the application, IMHO. Or at least retrofitted
with a human code review.
But perhaps because I've always taken this approach in my apps, the T5 was
pretty much a non-issue for me, even though I use multi-MB databases. I added
some calls to DmSyncDatabase() etc to ensure data integrity if the unexpected
happens, but I've really not had other problems with it.
>Are you trying to say that Palm
>(One/Source) should not do something to help developers work around
>this problem?
No, I'm only saying the proposed wrapper would be too simplistic for a general
purpose solution, IMHO.
>I still have to wonder why a library hasn't been developed
>to make this process simpler ages ago.
Probably a few reasons:
1) Using something like Nutshell or Combiner or ZBoxZ, you can get the same
install speed benefits, though it still needs to be decompressed on the
device. (I don't do this because I already have few, large physical
recs.)
2) It is relatively easy to roll your own logical access wrappers.
3) Often when you deal with databases of this size, you have other issues to
resolve too, such as a need for multiple indexes. For example, I may
want to lookup customers by name or phone number or customer number;
or inventory by UPC or SKU or description or whatever. I store both
the raw
data plus all my cross-reference indexes in a single pdb, meaning I need
specialized access routines not generic logical to physical mapping.
Doug
--
For information on using the Palm Developer Forums, or to unsubscribe, please
see http://www.palmos.com/dev/support/forums/
