I doubt it will take 10 minutes if you place the requests simultaneously. The server is the bottleneck, and the same amount of work still needs to be done by the server. You might want to look into optimizing your queries.
If you want to try it out, the simplest way would be to write your program such that it accepts the .sql file name as an argument, then you can do:
# unix myscript.pl file1.sql & myscript.pl file2.sql & myscript.pl file3.sql & myscript.pl file4.sql & myscript.pl file5.sql & myscript.pl file6.sql &
# Windows start perl myscript.pl file1.sql start perl myscript.pl file2.sql start perl myscript.pl file3.sql start perl myscript.pl file4.sql start perl myscript.pl file5.sql start perl myscript.pl file6.sql
In reply to Re: Multithreading and DBI
by ikegami
in thread Multithreading and DBI
by knsridhar
| For: | Use: | ||
| & | & | ||
| < | < | ||
| > | > | ||
| [ | [ | ||
| ] | ] |