My Team is implementing a Sorted Binary Search on a database of 100,000
records.
This means that there is no more than 18 lookups before determining
whether a record exists.
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, March 16, 2000 6:56 AM
> To: Palm Developer Forum
> Subject: RE: Palm Databases
>
>
>
> I like the idea denormalize database for Palm. Since these tables are
> not
> linked by keys, it requires reading data from each Palm database until
> the
> matching key is found. This greatly affects the performance.
>
> There should be some Palm programmers who write multi-database
> applicaitons.
> How do you handle the data linking?
>
>
> -Elizabeth
>
>
>
>
> [EMAIL PROTECTED] on 03/14/2000 01:19:40 PM
>
> Please respond to [EMAIL PROTECTED]
>
> To: [EMAIL PROTECTED]
> cc:
> Subject: RE: Palm Databases
>
>
>
>
> You don't have to redesign the database into one table. However, keep
> in
> mind that even if you use several databases on the palm (1 for each
> table),
> it's not relational, so you can't do joins or indices very easily. It
> seems
> best to keep databases at lease somewhat denormalized for performance
> reasons on the palm.
>
> Zoltan
>
> > -----Original Message-----
> > From: [EMAIL PROTECTED]
> > [mailto:[EMAIL PROTECTED]]On Behalf Of
> > [EMAIL PROTECTED]
> > Sent: Tuesday, March 14, 2000 2:37 PM
> > To: Palm Developer Forum
> > Subject: Palm Databases
> >
> >
> >
> >
> > Hi All,
> >
> > I am writing an application using data from 15 database tables
> > (Oracle). It
> > looks like a typical Palm application uses one table. Should I
> > redesign the
> > database to combine some tables? Thanks.
> >
> >
> > -Elizabeth
> >
> >
> >
> > --
> > For information on using the Palm Developer Forums, or to
> > unsubscribe, please see
> http://www.palm.com/devzone/mailinglists.html
> >
>
>
> --
> For information on using the Palm Developer Forums, or to unsubscribe,
> please
> see http://www.palm.com/devzone/mailinglists.html
>
>
>
>
>
>
>
>
> --
> For information on using the Palm Developer Forums, or to unsubscribe,
> please see http://www.palm.com/devzone/mailinglists.html
>
>
--
For information on using the Palm Developer Forums, or to unsubscribe, please see
http://www.palm.com/devzone/mailinglists.html