From: "George Bassili" <[EMAIL PROTECTED]> > > I come from a relational database background so I automatically just put > them in 2 databases for my app. > Each structure is about the same size in each table, probably on average > between 1 and 2k. > Now i've realised that when i want to retrieve the order lines, i need to go > through every record in the database to discover the appropriate ones.
If you index (i.e., "sort") OrderLines by the order number, I don't think you'd have to go through every record to find an order's items. -- For information on using the Palm Developer Forums, or to unsubscribe, please see http://www.palmos.com/dev/support/forums/
