hi bob. thanks for the reply. i am looking at like 14 or so tables, and i figured i
don't want all those handles open at the same
time. this is my first database program so i'm not sure if this is a rational concern
or not. some of the tables will have only a
few records, while others will have as many as a few thousand records. do you think i
should actually implement one database for
each table instead of one database with a table id?
thanks,
kevin
Bob Whiteman wrote:
> I've implemented a fairly simple relational database for an appliation.
>
> One problem with your suggested approach below is that it may be very tricky
> to sort the tables. Also, searches and inserts will take longer because they
> have to deal with a much larger Palm database.
>
> I used separate Palm databases for each table in the logical database. That
> way each table can have its own simple sort routine.
>
> Is there any particular reason why you don't want to create multiple Palm
> databases?
>
> -Bob Whiteman
>
> > -----Original Message-----
> > From: K. Chugh [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, July 27, 2000 7:45 AM
> > To: Palm Developer Forum
> > Subject: multi table relational databases
> >
> >
> >
> > hi- i'm paranoid about introducing a new layer to my apps by using
> > sybase ultralite, etc. does anyone know of any techniques for using
> > multi table databases? i was thinking of opening one
> > database and using
> > the category for the table identifier then just inserting
> > records in the
> > appropriate "table." has anyone tried this?
> >
> > thanks,
> > kevin
> >
> >
> > --
> > 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/
