good chemistry is complicated, and a little bit messy -LW |
|
PerlMonks |
Re^2: faster with threads?by hakkr (Chaplain) |
on Jun 09, 2004 at 13:16 UTC ( [id://362720]=note: print w/replies, xml ) | Need Help?? |
One thing to watch out for is DBI thread/fork safe? I seem to recall having problems with database connections 'going away' when using database handle inside forked off child processes. I resolved this by each child process recreating it's own database handle.Another thing to watch is maybe if the DB and log reside on the same disk then you could have decreased performance if doing major I/O on both at once, Hence maybe try and read the whole log into memory
In Section
Seekers of Perl Wisdom
|
|