Jim,
My data used to be hard coded into my app but now I am porting to
Android and the rules have changed. I need smaller subs so the database
fills the need to make my large subs smaller due to hard coded data. So
in reality I just need a flat file or as you as say, a denormalized
Duncan,
Thanks for your comments. My db is small and the records are at less
than 200. The tables number 7 and the colums 18 not counting the primary
auto increment. The UPDATE method I ended up using took about 1 second
for the one colum I moved or copied. I am just using this db as "read
The appropriate structure of the database depends on whether you need the
tables spread out into multiple tables for consistency ("one fact in one
location") -- a process called "normalization or whether you want all the
data in one table for ease of querying ("denormalization").
Transactional
On 2015-03-07 9:59 AM, Simon Slavin wrote:
> On 7 Mar 2015, at 4:42pm, Dave wrote:
>
>> I am fairly new at this although I have wanted to learn and tried again and
>> again...But I have a problem. I created a database and probably did it wrong
>> and I am trying to fix it. I made a database
4 matches
Mail list logo