Computer Science Canada xajax problems... |
Author: | Robert [ Sun Jan 21, 2007 10:16 am ] |
Post subject: | xajax problems... |
Has anyone here played around with xajax (http://www.xajaxproject.org/) ? I've been using it frequently at www.friendcodes.com, but I've begun seeing problems when I constantly query a mysql database in a loop. It seems that browsers time out anywhere between 5 and 60 minutes after starting the script. I have successfully had looping ajax work flawlessly before, but now that there is a heavy load on the mysql database, it seems to time out more easily now. My question is, do you guys have any suggestions (such as alternatives) for what I'm trying to do? My service is http://www.friendcodes.com/forums/view.php?pg=fwc. |
Author: | octopi [ Sun Jan 21, 2007 1:07 pm ] |
Post subject: | Re: xajax problems... |
Hello, I'm too lazy to register for that link you posted, but I don't really understand why your making mysql_query calls in a loop? You can't pull all the data you need, then just loop threw the data....would be way more efficient to do it this way. Maybe some example code/db structure/what your trying to do exactly |
Author: | Robert [ Sun Jan 21, 2007 1:09 pm ] |
Post subject: | RE:xajax problems... |
I need to continously get an updated list of who's online in the room. |
Author: | octopi [ Mon Jan 22, 2007 1:14 am ] |
Post subject: | Re: xajax problems... |
Hmm, my guess would be that theres a memory problem with the ajax code. If I recall I has some problem like that, but I wasn't using xajax, I was using something else. when you leave it running do you notice alot of memory/cpu usage in task manager? |
Author: | Robert [ Thu Jan 25, 2007 7:22 pm ] |
Post subject: | RE:xajax problems... |
Do you mean on the browser? Because yes, I do. |
Author: | octopi [ Thu Jan 25, 2007 9:47 pm ] |
Post subject: | Re: xajax problems... |
Yes, on the browser, I remember I had similar problems, if I recall correctly it had something to do with how i was displaying the results in the browser, i think i had to use a different javascript function, i'm not entirely sure what it was. you'll probally have to search google for ajax memory leak or something. I'll look and see if i can figure out what it was for me, but i can't promise anything sorry i can't help you more. |