PHP page with SQL query stays on "transferring data"

lonewolf217

I have several simple pages that query a SQL database and output some data. When I load the page, the data shows nearly immidiately, but the firefox and IE status bars still show "transferring data from page" for about 5 extra seconds every time. I am trying to figure out what the delay is because it is making working with AJAX nearly impossible since i have to wait 5 seconds for every update.

There are no problems with my query, it executes immidiately and the result sets are very small, plus like I said the data is displayed immidiately. I am just trying to find out what might be loading to cause the 5 second delay.

Anyone have any ideas ?

sneakyimp

I'm not at all sure, but the page that returns a response to your AJAX request should probably send a length [man]header[/man] which describes how long the response is?

Roger_Ramjet

Personally I use Prototype for all my AJAX and have never had any problems like that. But then I also send </body></html> as well so the ajax should know it has got all.

sneakyimp

I was impressed with the YUI Connection Manager.

Inkeye

Try a very very simple HTML-only version of your page with just the results of your queried data being displayed in a simple HTML table.

If this works without the extra "transferring data", then it likely has nothing to do with your query or the database. "Transferring data" can mean anything: a big CSS style sheet, a large javascript file, a big graphic, ...especially if you have caching turned off in your browser (and I bet you do!)