Browser issues with AJAX, PHP and MySQL

Browser issues with AJAX, PHP and MySQL

Author
Discussion

mystomachehurts

Original Poster:

11,669 posts

252 months

Friday 14th December 2007
quotequote all
A web page has a click function that submits a set of filters to the DB via a php page via AJAX.

The php page just performs a count of the records that match the filter criteria submitted in the AJAX request (grabbed fro ma form on the HTML page)

If this takes a long time to perform, is there a way to get the browser to stop the process that is running on the server performing the query?

I've got a few impatient customers that are complaining about the speed of this Application, what I'm seeing is that even if you click out of the web page that is waiting for the result it doesn't stop the MySQL MySQL process on the server from spinning out of control...

Boo Hisss


We're running CentOS:2.6.9-55.0.2.plus.c4smp #1 SMP Fri Jul 6 05:25:07 EDT 2007 i686 i686 i386 GNU/Linux
(and currently testing a 64bit 5 version of this OS)

MySQL is currently V5.0.44

Any thoughts?