Do you know where your variables are? | |
PerlMonks |
Re^3: SQLite and large number of parametersby Jim (Curate) |
on Dec 10, 2012 at 19:26 UTC ( [id://1008155]=note: print w/replies, xml ) | Need Help?? |
I agree with bart. I don't think it's as complicated a problem as you're making it. You have a relational database. You have a problem that is trivially solved using a relational database. Just INSERT the values INTO temporary tables and either use WHERE EXISTS (if SQLite supports it) or INNER JOIN on the tables instead. Don't knock yourself out trying to work around the limitations of the WHERE … IN clause. It simply doesn't scale to your requirements. Jim
In Section
Seekers of Perl Wisdom
|
|