Re: Perl scripts to run concurrent commands on MySQL

[Michael T. Babcock]

Geetika Tewari wrote:

Does anyone please have any Perl scripts to execute concurrent
SELECT commands on MySQL?  Any scripts that do not use fancy libraries
would help. Please help. Thanks.

Read up on 'fork' and make yourself a "fork_do_query" function of some form so you can call:

my $results1;
my pid1 = fork_do_query("SELECT * FROM Cust", $results1);
my $results2;
my pid2 = fork_do_query("SELECT * FROM Cust", $results2);

... (wait for pid1, pid2) ...
... (use results) ...

--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock



---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php