this question goes on from my previous one about my 1st hurdle using
what sort of performance hit will you get if you have 3 select
statements (1 for each table/DB file)?
tables are customer, Jobs, parts.
customer has a unique field called customer number.
Jobs has a field for the customer number in it and a unique field called
lastly parts has a field called job number.
not sure how many rows there might be for a customer and rows for parts
but really I’m more concerned with getting everything playing in tune
and then when I’m more familiar wit SQLite look at optimizations like
an yes ultimately i may move off sqlite to another DB but that’s another
Oh also all this is via DBI.
Active record will be another stepping stone (Feel like I’ve got too
much to cope with for now but perhaps ultimatly go to active record