Beefy Boxes and Bandwidth Generously Provided by pair Networks
laziness, impatience, and hubris
 
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
Replies are listed 'Best First'.
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 meditating upon the Monastery: (5)
As of 2015-07-28 05:17 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (252 votes), past polls