![]() |
|
![]() |
|
|
Thread Tools | Display Modes |
|
|
|
|
#1 |
|
PHP God
|
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
__________________
mysql_query("DELETE chavs FROM earth") or die("chavs"); |
|
|
|
|
|
#2 |
|
Programming Guru
![]() |
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. |
|
|
|
|
|
#3 |
|
PHP God
|
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?
__________________
mysql_query("DELETE chavs FROM earth") or die("chavs"); |
|
|
|
|
|
#4 |
|
Programming Guru
![]() |
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.
|
|
|
|
|
|
#5 |
|
PHP God
|
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 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.
__________________
mysql_query("DELETE chavs FROM earth") or die("chavs"); Last edited by FireflyX; Dec 21st, 2007 at 12:11 PM. |
|
|
|
|
|
#6 |
|
Programming Guru
![]() |
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.
|
|
|
|
![]() |
| Bookmarks |
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Option to increase the number of threads listed | peace_of_mind | Community Announcements and Feedback | 6 | Jul 21st, 2006 6:41 AM |
| Why MHz isn't a good measurement of speed when comparing Intel and AMD | a thing | Coder's Corner Lounge | 6 | Dec 18th, 2005 11:57 AM |
| Darkhack's cpu speed tester | JDStud6 | C# | 6 | Dec 17th, 2005 6:44 PM |
| fastest download speed | darkone916 | Coder's Corner Lounge | 17 | Aug 1st, 2005 10:22 PM |
| speed script | Bmxer_Jake | JavaScript and Client-Side Browser Scripting | 2 | Jun 25th, 2005 11:36 AM |