I've been planning on using roughly 4-5 databases for a palm application. Where each of these DB's would represent a Table. Ex. DB1 = Clients DB2 = Employees etc...
I figure i will have only one type of structure in each DB. Anyways, i'm planning on doing joins based upon certain fields between the various db's. The goal, is to have something which mimics the functionality of a sql style db and keeps the data logically organized in separate databases. My question is: Will there be a serious performance issue(on joins/queries)? I'm assuming that there could be somewhere near 5000 records per DB. More than this is unlikely, Is this a good approach or not? I really do not want to shove all data into one DB. Is there a better way to represent tables under palm os(vs. one db per table)??? -- For information on using the PalmSource Developer Forums, or to unsubscribe, please see http://www.palmos.com/dev/support/forums/
