in reply to DBI Efficiency
Instead of *, name the fields explicitly. This has the added benifit of yielding useful errors if a schema change affects field names. (With *, both the order of fields and field names could changes, and you might never know it, other than noting that you're getting corrupted results from your script.)
In your case, this means
And for heavens sake, arrange to detect or trap errors from DBI.SELECT name, age FROM mytable WHERE id=?
|
|---|