Re: SQLite and large number of parameters

Not sure if it's faster, but you could always try not using placeholders:

my $sql = sprintf q[
SELECT *
FROM my_table
WHERE 
   col_1 IN (%s) AND
   col_2 IN (%s)
], join(', ', @$set_1), join(', ', @$set_2);
[download]

If you can't be sure that they are all integers, be sure to map then through $dbh->quote first.