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
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