-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Joe
Malone
Sent: Tuesday, July 09, 2002 10:01 AM
To: Palm Developer Forum
Subject: Re: Record Size v performance
>But I don't understand what you mean by not having to repeat info.
>Other than including a key field for record identification, the whole
>point of using relational design (as opposed to a flat-file db design)
>is so you don't have to repeat unnecessary info.
My point exactly. I suppose what I meant precisely is that, although the
new scheme does not look like a RDB design, it still keeps the advantage
that info is not repeated (ie stored twice). This was perhaps a redundant
or pointless statement. I have been accused on many occasions of being
"pedantic" :).
--- Paul Gibson <[EMAIL PROTECTED]> wrote:
> I'm designing a new app and am rethinking the way I use "databases"
> in PalmOS. My first few apps have studk with parralleling desktop
> RDBs with several tables relating data by an ID field (or some such
> thing). I am now thinking that this is flawed, as PalmOS does not
> give any SQL type capabilities. So for this new app I'm thinking
> that I can store one record of data for each person. The record will
> have all of their data, that would on the desktop be stored across
> several tables. In this way I don't have to repeat info, and don't
> have to do multiple table (DmQueryRecord) operations to gather data.
> However, I would then be pushing the record size pretty high. It
> seems like this method would improve performance, but I am gambling
> on the increase in record size not hindering performance somehow.
> In general is this correct?
In the general case, yes. If you store one person's data in multiple
dbs, you have to lock/unlock several records to get that data. This
will probably be slower than keeping all of the data in one record.
Also, sync time will typically be much less with a few large records
than it will be for many small records.
But I don't understand what you mean by not having to repeat info.
Other than including a key field for record identification, the whole
point of using relational design (as opposed to a flat-file db design)
is so you don't have to repeat unnecessary info.
__________________________________________________
Do You Yahoo!?
Sign up for SBC Yahoo! Dial - First Month Free
http://sbc.yahoo.com
--
For information on using the Palm Developer Forums, or to unsubscribe,
please see http://www.palmos.com/dev/support/forums/
--
For information on using the Palm Developer Forums, or to unsubscribe, please see
http://www.palmos.com/dev/support/forums/
