Re: DBI and SQLite efficiency

2009-01-13 Thread Rob Dixon
Southworth, Harry wrote: > I have a database with several tables in it, and each table contains data on > lots of people. From one run of my program to the next, the tables could > change, so my code needs to be fairly general. > > I want to pull the data for each person from each table, and cre

RE: DBI and SQLite efficiency

2009-01-13 Thread Jenda Krynicky
From: "Southworth, Harry" > I think that if I append (rather than overwrite) each report with each > table, I could restructure the code like you suggest. Thanks for > pointing that out - it hadn't occurred to me. > > > my %sth; > > for (0..$#tables){ > > $sth{$tables[$_]} = $dbh->prepare( > >

RE: DBI and SQLite efficiency

2009-01-13 Thread Southworth, Harry
Thanks. I think that if I append (rather than overwrite) each report with each table, I could restructure the code like you suggest. Thanks for pointing that out - it hadn't occurred to me. > my %sth; > for (0..$#tables){ > $sth{$tables[$_]} = $dbh->prepare( >"SELECT * FROM $theTable WHER

Re: DBI and SQLite efficiency

2009-01-13 Thread Jenda Krynicky
From: "Southworth, Harry" > I have a database with several tables in it, and each table contains > data on lots of people. From one run of my program to the next, the > tables could change, so my code needs to be fairly general. > > I want to pull the data for each person from each table, and cr