Don't ask to ask, just ask | |
PerlMonks |
SQLite and large number of parametersby menth0l (Monk) |
on Dec 10, 2012 at 10:14 UTC ( [id://1008081]=perlquestion: print w/replies, xml ) | Need Help?? |
menth0l has asked for the wisdom of the Perl Monks concerning the following question:
I have a sqlite table that has two columns: COL_A and COL_B (both integer). Now i want to select some records where col_a has values from one large (hundreds, maybe few thousands) set and col_b has values from another large set:
This will result in error:
My attempt to go around this problem resulted in this code.
This actually works but i wonder if there is a more convenient (and faster!) way to do selects with large IN statements. I can't use BETWEEN operator since those values aren't continuous. Any ideas?
Back to
Seekers of Perl Wisdom
|
|