[VPM] sqlite and perl for performance

Darren Duncan darren at darrenduncan.net
Sat Mar 12 21:36:43 PST 2011


Jer A wrote:
> I want to get data from multiple databases using sqlite.
> 
> instead of processing command at a time, or a chain sequence,
> 
> I would like to execute them in multiple threads, and have them all join.
> 
> this is going to be used in a cgi script, and possibly a cron job. 
> 
> are there any issues using sqlite and perl in this manner?
> 
> thanks in advance for your input.

Do you realize that you can use multiple SQLite databases simultaneously through 
a single DBI connection?  You just CONNECT to one of them as usual and then 
issue "ATTACH" SQL to make others visible at the same time, as if they were 
parts of a larger database.  You can even do cross-database queries, natively in 
SQLite; you don't have to join them in your application. -- Darren Duncan


More information about the Victoria-pm mailing list