Re^2: Complete part of a cgi script before the rest

Oh that was ridiculously easy.

I did have to fix an error in my script above.

If you look, you'll see that I execute my query in the line just before the HTML is generated. So at first when I added the daemonize call just after the HTML closed I was still getting the long delays.

Once I moved all of the MySQL stuff into the same area (below the HTML) it worked perfectly.

Just one more reason to use subroutines to keep my code clean. I kill myself with messy code. :(

Comment on Re^2: Complete part of a cgi script before the rest

Replies are listed 'Best First'.
Re^3: Complete part of a cgi script before the rest by frieduck (Hermit) on Apr 15, 2010 at 20:28 UTC
Just a thought. You may want to consider having the CGI process just queue a request to a daemon to prevent your server/database being overloaded by multiple simultaneous requests. You would simply do an insert into a request queue table with any necessary parameters, and have the daemon periodically check for new requests.	[reply]
Re^4: Complete part of a cgi script before the rest by afoken (Chancellor) on Apr 16, 2010 at 20:00 UTC
Right. And if you use a cron job to run a simple script as often as required, you don't even have to write a daemon. Alexander -- Today I will gladly share my knowledge and experience, for there are no sweeter words than "I told you so". ;-)	[reply]