> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > > So, if I've got a massively parallel database, and I want to run > a batch of queries against it in parallel--let's say five hundred, > six at a time, what would be the best way to do that? My first thought > was a fork/connect for every query, but that's way too much overhead.
Six connections wouldn't be much. Fork the processes, connect each to the database, and use IO::Socket and IO::Select to feed the child processes queries. Thats what I did with my upd_stats utility (the utility is just for Informix databases, but the principle is there), at http://www.iiug.org/ver2/software/index_DBA.html
