If the PDB is static, then you could try writing your own access
routines and cutting down the number of records. We've been working on a
project where we have a 300K database that has hundreds and hundreds of
records (I can't recall how many) that is broken into 6 chunks of under
60K each (instead of hundreds of database manager records). We then lock
down the records at start and use our own access routines to get to the
data. It is extremely fast and works quite well. Even if the data wasn't
static, you could use some of the same principles.
It is definitely more work than using the built-in database manager, but
it does solve a problem.
In article <12285@palm-dev-forum>, Steve Sabram <[EMAIL PROTECTED]>
wrote:
> Some databases engines have their own memory management by updating an
> offset table to arrange memory chunks sp they appear
> contiguous at the API level but not in physical memory. Thus you can add
> in records at position zero and no memory is moved; only
> the record management table is updated. I'd like to hear a comment from
> Palm on this one.
>
> Steve
>
> Mitch Fawcett wrote:
>
> > The code for unmunging the 64k chunks... could that be made more
> > efficient?
> > I'm thinking for example that every time you insert a record into the
> > database the OS goes through each record above it and bumps the index.
> > That
> > means that in a worse case, if you added every record at index zero,
> > you
> > would force the OS to loop through every record you had previously
> > added;
> > proportionally increasing the amount of time it takes to add a new
> > record.
> > On the other hand, if you add the record to the end of the database
> > instead,
> > you eliminate all that OS looping. Here's hoping I haven't just stated
> > the
> > obvious.
> >
> > Mitch Fawcett
> > Tapn'see Software
> > (Home of SuperList2)
> > http://www.tapnsee.com
> >
> > >-----Original Message-----
> > >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> > >Sent: Friday, May 19, 2000 5:46 PM
> > >To: Palm Developer Forum
> > >Subject: Sending large PDB files to the Palm
> > >
> > >
> > >I have a large pdb file with over 15000 records that i need to send to
> > >the
> > >palm
> > >I have tried several different methods but all seem to take upwards of
> > >an
> > >hour
> > >
> > > I have tried using the palm install tool,
> > > I also wrote two conduits, one to download the records
> > > individually
> > > and another that combines several records into 64k chunks
> > > The last conduit hotsyncs very fast but then requires the palm to
> > >process
> > >the
> > > records which again takes over an hour
> > >
> > > Is there any way to do this quickly? The table is going in one
> > direction
> > >
> > >from the pc to the palm
> > >
> > >--
> > >For information on using the Palm Developer Forums, or to unsubscribe,
> > >please see http://www.palmos.com/dev/tech/support/forums/
> > >
> > >--
> > >For information on using the Palm Developer Forums, or to unsubscribe,
> > please see http://www.palmos.com/dev/tech/support/forums/
> > >
> > >
> >
> > --
> > For information on using the Palm Developer Forums, or to unsubscribe,
> > please see http://www.palmos.com/dev/tech/support/forums/
>
>
>
--
Scott Gruby
[EMAIL PROTECTED]
<http://www.gruby.com/>
--
For information on using the Palm Developer Forums, or to unsubscribe, please see
http://www.palmos.com/dev/tech/support/forums/
