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};

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

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 concurrent

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

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

2002-11-25 Thread Geetika Tewari
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 want to monitor the behaviour of MySQL with native ISAM tables under