Re: server response slowing down

Hi Erwin,

Thanks for this, but if I start at question 20, and navigate backwards to
question 1, it still starts to slow down at question 5, so doesn't seem to
be the answer...

Cheers anyway,
Chris.



"Erwin Moller"
<since_humans_read_this_I_am_spammed_too_much@xxxxxxxxxxxxxxxx> wrote in
message news:44d08c5e$0$4525$e4fe514c@xxxxxxxxxxxxxxxxx
Chris Thompson wrote:

Hi All,

I have a private website created using HTML/PHP. Within this site, there
is a page that has a form (question.php), which is populated depending on
the question number that has been posted to it.

When the form is submitted, the data is posted back to the same page
(question.php), and the code within the page saves the posted data, and
displays the next question, and so it goes on...

While the page loads almost instantly for the first 15 or so questions,
the server response gets gradually slower, to the point where the page
takes about 30 secs to start loading after about 18 questions.

I'm trying to understand what may be causing the lag... It doesn't seem
to be the loading of the page that's taking the time, it's the response
time from the server before the page starts loading that seems to
increase.

The page does use MySQL tables, but all are well indexed, and as I say,
you can load the page about 15 times, before any noticeable delay starts
to happen.

Anyone any ideas please?

(I've put the complete site on 2 different servers - 1 on a shared
hosting
account, and 1 on completely different managed server, and the same thing
happens on both servers!?).

Thanks,
Chris.

Hi Chris,

That indicates that your script has a higher workload the higher the
questionnumber is.
That could indicate that the script is doing more work for question number
20 than for question number 1.

Do you only perform the quesries needed?
Are you maybe 'counting' by doing subsequent databasequeries untill you
pulled the 'right' question from the table(s)?

Regards,
Erwin Moller


.

Relevant Pages

  • Re: server response slowing down
    ... I cannot think of any valid reason why the database or your script gets slow ... "Erwin Moller" ... the server response gets gradually slower, to the point where the page ... takes about 30 secs to start loading after about 18 questions. ...
    (comp.lang.php)
  • Re: server response slowing down
    ... the server response gets gradually slower, to the point where the page ... takes about 30 secs to start loading after about 18 questions. ... That indicates that your script has a higher workload the higher the ... That could indicate that the script is doing more work for question number ...
    (comp.lang.php)
  • Re: Help - PHP5 with IIS5 on WinXP SP2 Pro
    ... Polaris wrote in news:4145dccf$0$62367$5fc3050@dreader2.news.tiscali.nl: ... > Does the server give the complete text of the browser.php script? ... loading. ...
    (alt.php)
  • Re: imagettftext problem
    ... monomaniac21 of comp.lang.php make plain: ... Have you tried loading the script, on the non-working server, directly? ...
    (comp.lang.php)
  • Re: Same Internal Server Error from last two days
    ... I am trying to run a Hello World Perl Script in Apache 2.2. ... But its constantly giving me Internal Server Error.The script ... # have to place corresponding `LoadModule' lines at this location so the ...
    (perl.beginners)