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
