Re: Executing concurrent select statements from perl on MySQL ISAM tables(fwd)

2002-11-26 Thread Rodney Broom
Sorry, Geetika. It looks like I lost this thread in the mix. Have you tried some Perl like this: # concurrent.pl # Check start time. for my $n (1..$DO_TRIES) { print qq{Doing # [$n] PID [$$]\n}; my $pid = fork(); if ($pid == 0) { print qq{Child [$$] running command.\n}; exec(qq{e

Executing concurrent select statements from perl on MySQL ISAM tables(fwd)

2002-11-25 Thread Geetika Tewari
12:38:45 -0500 (EST) To: [EMAIL PROTECTED] Subject: Executing concurrent select statements from perl on MySQL ISAM tables (fwd) I am trying to make my perl script fork several processes that all execute 'select' statements on MySQL. I want the statements to happen concurrently (as I wa

Re: Executing concurrent select statements from perl on MySQL ISAM tables(fwd)

2002-11-25 Thread Rodney Broom
From: Geetika Tewari <[EMAIL PROTECTED]> > ...perl script fork several processes... > ...I think my 'select' statements are not happening concurrently. Why do you think that? --- Rodney Broom President, R.Broom Consulting http://www.rbroom.com/ sql ---

Re: Executing concurrent select statements from perl on MySQL ISAM tables (fwd)

2002-11-25 Thread Dan Nelson
In the last episode (Nov 25), Geetika Tewari said: > I am trying to make my perl script fork several processes that all > execute 'select' statements on MySQL. I want the statements to > happen concurrently (as I want to monitor the behaviour of MySQL with > native ISAM tables under this concurren

Executing concurrent select statements from perl on MySQL ISAM tables(fwd)

2002-11-25 Thread Geetika Tewari
I am trying to make my perl script fork several processes that all execute 'select' statements on MySQL. I want the statements to happen concurrently (as I want to monitor the behaviour of MySQL with native ISAM tables under this concurrent Read access). So I am using 'fork'. However, I think my