A question of performance?

2001-04-27 Thread Davin Flatten
Hello everyone, I have a quick question of performance. Which is faster with the Perl DBI: 1. One SQL query that retrieves a large amount of data and then lets Perl decide what to do with each row. i.e. this row is a foo1 do this, this row is a foo2 do this. 2. Several SQL queries that

Newbie question - Hopefully not too stupid!

2001-04-26 Thread Davin Flatten
Hello all! Here is what I am trying to do. I am trying to find only records that all have the same value for a specific field in a related table. A simplified example: Table1 has 2 fields - id, name Table2 has 2 fields - id, offon Given these sets: Table1 id name --- 1 Red 2