Your way of doing it seems perfectly fine. The typical way to do selects with DBI is:

• prepare
• execute
• fetch

The fetch is typically done in a loop (either in the program, or by the DBI), and you can have multiple execute/fetch cycles for a prepare (another advantage of placeholders).

Since the second query doesn't depend on the results of the first, doing all the actions of the first before starting with the second is fine.

No doubt I would write it differently than you, but in essence, it would still do the same, in the same order.

Abigail