Programming Forums - I need speed increase

Programming Forums (http://www.programmingforums.org/forumindex.php)

- JavaScript and Client-Side Browser Scripting (http://www.programmingforums.org/forum23.html)

- - I need speed increase (http://www.programmingforums.org/showthread.php?t=14782)

I need speed increase

I just finished my active users script for my site and we all see active users lists on lots of sites and forums but i thought i'd try and make mine a bit more interesting by making it every once in a while without you having to reload the page. The script itself works fine but after about a minute the site just freezes. Now i really want to have the script there because it's a lot better than your ordinary boring active users list but i was wondering is there any way i can stop this freezing from happening. Here is the code i'm using to achieve this:

function Active (){



  self.status = "Sending request"



  initialize();

  xmlHttp.onreadystatechange=function()

  {

    if(xmlHttp.readyState == 4){



      var active = document.getElementById('active');

      active.innerHTML = xmlHttp.responseText 



    }

  }

  xmlHttp.open("GET", 'http://www.staticfire.co.uk/ajaxrequest.php?cmd=active',true);

  xmlHttp.send(null);



}





var delay = 20000

var timerID = setInterval("Active()", delay)

Do you think it is this that is causing the freezing or the would it most likely be the PHP causing it?

-Thanks for your time :icon_cheesygrin:

Re: I need speed increase

Switch the URL to something static. Maybe 'http://www.staticfire.co.uk/ajaxrequest.html'.

Make sure the page exists.

Then run that for a couple minutes. See if it still freezes. This will help isolate your problem, because it will help determine whether it's JS, or PHP, that's causing the problem.

Re: I need speed increase

Good idea.

And the result is as i feared: the PHP is causing it and i don't know how to increase the speed. UPDATE is one of the slowest MySQl quieries and it is being used in that file. If i were to post the PHP here do you think anyone would be able to increase the speed of it?

Re: I need speed increase

Well I believe I already previously attempted to fix your query. Hopefully you applied, or at least tested, my suggestions. Go ahead and post it here. Someone will help you I'm sure.

Re: I need speed increase

What? When did you do this?

Edit: Oh it seems i posted a thread here about my site being slow before. I forget :D Anyway I did try out what suggested but it still seems to be slow. Anyway i'll try and speed it up a bit myself then i might have to post the code if it continues to be slow.

Re: I need speed increase

Also, don't spend too much time hitting your keyboard over this. One possibility could be poor MySQL support by your hosting service. There are different degrees of speed, caching, and size, that your hosting service can set restrictions upon. Make sure you aren't doing anything that would cause them to delay you between queries.