What you are trying to do looks suspiciously concurrent. How about a simpler
solution:
############## snip##
$qh = $dbh->prepare("blabla");
$qh->execute;
print "SQL is busy processing your query, please wait ...\n";
@results = $qh->fetchrow_array;
print "... Processing complete.\n";
############## snip ##
Not very grand, I know, but it kind of does what you want. Even if your
solution was possible, it would slow your query down even more.
Maria
On Thu, 9 Aug 2001, Giotto De Filippi wrote:
> No, I do not mean forking.
>
> I want my program to be single threaded. What I want would be somehting like:
>
> $qh = $dbh->prepare("blabla");
> $qh->execute;
>
> while (!$qh->is_ready)
> {
> print "SQL is busy processing your query, please wait...\n";
> }
>
> @results = $qh->fetchrow_array;
>
> thanx for your help
>
> At 08:16 AM 8/9/2001 -0600, Sterin, Ilya wrote:
> >You mean forking??? You can do anything in the background by creating
> >another process with fork(). You can also use Thread, though I don't know
> >how stable it is as of now.
> >
> >Also note that you will not achieve parallel processing unless you are on a
> >multi-processor system, but that's irrelevant to the simple task you are
> >trying to accomplish.
> >
> >Ilya
> >
> >-----Original Message-----
> >From: Giotto De Filippi
> >To: [EMAIL PROTECTED]
> >Sent: 8/9/01 7:43 AM
> >Subject: background sql queries
> >
> >(Sorry, may be a double post but I don't know if the other message went
> >throught as I was still not registered)
> >
> >Hello,
> >
> >Can I do SQL background queries with DBI?
> >
> >like instead of doing ->prepare, ->execute and ->fetchrow_hashref
> >something
> >like ->is_ready, to do before fetchrow, so for example I could do other
> >things with my perl program while it's waiting for the sql databsae to
> >return the result.
> >
> >Thanx much
> >
> >Giotto
> >
> >
> >
> >----------------------------------------------
> >Giotto De Filippi
> >Web Marketer / Programmer
> >E - Mail: [EMAIL PROTECTED]
> >ICQ: 17988776
> >----------------------------------------------
>
> ----------------------------------------------
> Giotto De Filippi
> Web Marketer / Programmer
> E - Mail: [EMAIL PROTECTED]
> ICQ: 17988776
> ----------------------------------------------
>
>
