On Wed, 18 Mar 1998, Fardad Kordmahaleh wrote:
> I am curious to know about the size of the
> largest db that can be handled by the latest
> palmPilot safely? (Considering maximum expansion allowed)
What exactly do you mean by "large"?
1. A single large .pdb or .prc file.
The largest I have tried is my monolithic bible reader that comes in at
1.2 Meg.
The only hiccups were caused by the hotsync taking a long time for this
single file. No timeouts normally, but low battery interruptions could be
annoying since I could get several during a single hotsync. If my
computer had problems and was busy a timeout might occur here but nowhere
else.
I have a test to do with one of my 12 Meg palms regarding data logging, so
I will see how big a file I can create then.
2. Many large records within a .pdb (Note records are limited to 64K).
Also no problem normally. There might be a functional problem if you are
doing something that involves adding to a large record it since you will
need enough unfragmented free memory to resize the record.
3. Lots of big (or small) databases.
The only problem here is that Palm does linear searches for some things,
at least as of 3.0. So when I had 400 databases, DmCreateDatabase would
take about 1/4 second to find I could or could not (due to a duplicate)
create a database. I think 3.1 is a lot faster, but haven't tested.
4. A large number of records in a single database.
I haven't tested this, but I would think adding one in the middle wouldn't
be that quick if there are thousands of records. And I suspect they may
have tweaked 3.1 here too.