Posted by Cord-Heinrich Pahlmann on 01/28/07 22:41

On 26 Jan., 13:04, Rik <luiheidsgoe...@hotmail.com> wrote:
> On Fri, 26 Jan 2007 12:54:01 +0100, Curtis <dye...@gmail.com> wrote:
> > On Jan 25, 11:04 am, "Cord-Heinrich Pahlmann" <S...@Heineken2000.de>
> > wrote:
> >> I have a little script which takes around 10 seconds execution time.
> >> In those 10 seconds the script does a lot of mysql_queries and changes
> >> some data.
> >> If the script stops after 5 seconds and restarts it will mess up my
> >> data.We've got a setting to ignore an abort:http://www.php.net/ignore-user-abort
>
> >> But it seems if php goes through the code and executes all the
> >> mysql-queries after it is finished (after the 10 seconds).
>
> >> So my question is, when does php executes the mysql-queries?
>
> > Once the client sends the request, the PHP is parsed by a running php
> > process (i.e. cgi or apache module). PHP's database wrappers
> > communicate with the database and handle the data.
>
> > It sounds like there could be a problem with your configuration or
> > code. This is probably the wrong avenue to explore to find a solution
> > to your problem.Yup, unless you're using some weird code I'd say PHP executes queries on
> executing. mysql_unbuffered_query can lead to some funky results sometimes
> though.
> --
> Rik Wasmus

Thank both of you for the answers. I'm was actually pretty sure, that
my code is OK. Those DB-Queries are pretty simple. I take some
blowfish-encrypted passwords from my DB decrypt them, encrypt them
with a newly generated key and then store them back into the DB.
I just thought that the de-/encryption takes so long. When I do this
with <10 passwords it is pretty fast. But when I do the same thing
with > 30 it takes at least 10 seconds.
I will look through my code again and do some more testing. Maybe I
have some weird loop hanging around somewhere.

The ignore_user_abort function is really nice. I think I will have
good use for it in this and future projects. Thx.

[Back to original message]