Long time responses echo my content

ropic

Hello,

I have a php script than sometimes in a day takes long time to echo my content

$starttime =
echo $content
$endtime =
$total = $endtime - $starttime

Is $total is greater than 30 seconds then i receive an email, my client is blocking my content because delays,

Do you have any idea what could be the problem ?

My script does at most 3 queries, then use a template to build my response, i get the content in a variable and then echo.

Thanks for your help

bpat1434

So what does your script look like? That's great that you're doing the timing, but what does your script actually look like?

If the page takes a while to load, it could be just a high usage load on the server, so it can't parse your template as quickly. It also depends upon how much information you're transmitting. Both of which, we can't tell unless you post more code.

justsomeone

It's hard to say why your script is slow without seeing the code. Since you mention that you are doing database queries, have you tried running the same queries in the commandline database client to see how quickly they run? It might be that you have a table which isn't properly indexed?

Another area which might be worth looking into is your looping. Do you have have many nested loops?

ropic

The delay is exactly where i echo my content, i have take times before for all queries and the time to "echo" my content increases a lot sometimes in a day, more than 100 seconds. Usually my final content is read from a file using join and file functions, i would like to repeat that the big delay is exactly in the line than echo my content. My responses are about 100KB

I have attached my code,

Some notes:
the most of the times (99%) it's only necesary to reach until first query and one more for saving my transaction
the xml i reveive is extremely small