Re^2: DBI qw(:sql_types) with placeholders versus SQLite3

Thanks, that solved the problem at hand. So I guess there is no way around creating a large query string on the fly, with or without place holders. I do like the sprintf approach, it is more elegant than the alternate approach which I had in mind.

Comment on Re^2: DBI qw(:sql_types) with placeholders versus SQLite3 Download Code

Replies are listed 'Best First'.
Re^3: DBI qw(:sql_types) with placeholders versus SQLite3 by hippo (Archbishop) on Mar 31, 2024 at 17:01 UTC
So I guess there is no way around creating a large query string on the fly, with or without place holders. Well, you could simply create a temporary table with your big list of items in it and join against it. Let the DB take the strain - that's what it's there for. 🦛	[reply]
Re^4: DBI qw(:sql_types) with placeholders versus SQLite3 by mldvx4 (Friar) on Apr 01, 2024 at 11:04 UTC
I would have offloaded the work to the database but the integers in question are from an already complex query involving a three-way join, one of which is a self-join. I'm just barely familiar enough with SQL that I can write the query and do have to think a bit each time I re-examine it. However, if those results can be cached in a temporary table while still preserving the results of that original query, then I'll explore that option just in case. For right now, I like the readability of the Perl-side processing.	[reply]