Use prepared statements #80

New issue

Open

opened 2020-08-06 16:54:34 +00:00 by gburd · 0 comments

gburd commented

2020-08-06 16:54:34 +00:00

(Migrated from github.com)

Wherever possible we should avoid parsing SQL.

We should also consider, after getting this working in the simple cases, whether it's better to loop over a prepared statement 300 times rather than to compose a 999-var SQL string and parse it.

Note that prepared statements will need to be closed at the appropriate time, and should ideally be lazily created as needed to avoid impacting time-to-open.

Wherever possible we should avoid parsing SQL. We should also consider, after getting this working in the simple cases, whether it's better to loop over a prepared statement 300 times rather than to compose a 999-var SQL string and parse it. Note that prepared statements will need to be closed at the appropriate time, and should ideally be lazily created as needed to avoid impacting time-to-open.