Beefy Boxes and Bandwidth Generously Provided by pair Networks
Keep It Simple, Stupid
 
PerlMonks  

Re: SQLite and large number of parameters

by moritz (Cardinal)
on Dec 10, 2012 at 11:53 UTC ( #1008090=note: print w/ replies, xml ) Need Help??


in reply to 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);

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


Comment on Re: SQLite and large number of parameters
Select or Download Code
Re^2: SQLite and large number of parameters
by menth0l (Monk) on Dec 10, 2012 at 13:40 UTC
    Thanks for suggestion, I will try that.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1008090]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others cooling their heels in the Monastery: (13)
As of 2014-07-14 12:44 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    When choosing user names for websites, I prefer to use:








    Results (259 votes), past polls