Subject RE: [ib-support] interrupted php script while accessing firebird. .. what happens?
Author Berenger Enselme
> > $dbh = ibase_connect(.....);
> > $stmt = "SELECT BLA, BLA...";
> > $sth=ibase_query($dbh,$stmt)
> > while ($row=ibase_fetch_object($sth)
> > {
> > ... printing result in the client browser
> > }
> >
> > If the result of the query is big enough, it may take some
> time to show all
> > the rows in the browser, and the user may get tired of
> waiting. If he stops
> > the script, does firebird continue processing the query
> until it finishes?
> I don't know about theory, but my experience shows that
> Firebird keeps
> running the query. Sometimes my users run a query like that, and when
> they see it isn't responding, they try to run it again, and
> the server
> gets stuck for a long time, so I just have to kill those ibserver
> processes. (I use Linux, Apache, PHP)

I would think it depends:
- if the query is *executed* fast but the *fetching* takes some time then
killing the script would stop the fetching (which is always done
incrementally) and thus relieve the server... (ex: SELECT * FROM HUGE_TABLE)
- if the query is of the long execution type (ex: select * from A_PROCEDURE
with A_PROCEDURE doing some complex treatments) then killing the script
wouldn't stop the query.