I have just reconfigured two machines (one mysql db, one php web server) here to run my LMS application.
I first noticed problems with it running really slowly in phpMyAdmin (first with phpMyAdmin on the web server, then with phpMyAdmin on the db server).
Thing is, it runs fine sometimes, (when I call some pages) and really slowly on others. It's like it will work beautifully for 10 page calls in a row, and then choke down and take 2 minutes to load the next (for no particular page order or reason).
I have been living with that and that's ok. My real problem surfaced today when the LMS application started having problems. A user created a new course and then submitted a new lesson in the course and it went to a "page can not be displayed" error. When she hit back and refreshed the form page, it shows that the lesson had been inserted to the db about 30 times...which tells me that it is processing it (muliple times) and might even be getting caught in some kind of loop which is making it throw the page not displayed error.
The second issue may not have ANYTHING to do with the first, but since I've had those two issues I thought they might be somewhat related. I KNOW it's not a coding issue on the LMS because it works great (most of the time), but every once in a while, we have this problem.
I have chatted with Feyd about the way I have the db server set up (the machine that I think is the problem given that when I have phpMyAdmin directly on that machine, it's still really slow) and we can't seem nail down any issues that could be driving this. I mentioned to him that I did the same install that I've done for every other mySQL install with the exception that I set it up for 500+ concurrent connections...could that be killing this? Why would it be looping the insert statement?
I'm at a total loss here.
please help if you have any ideas or suggestions.
thx,
Burr
Windoze PHP server having issues....really slow and more
Moderator: General Moderators
does you redirect the user?
if you conditionally redirect them, maybe your condition is being met more than you planned it to be met.
maybe they got stuck in an infinite redirection, and the browser said no more after 30 redirects and showed a built in error page(IE is famous for that). that could cause a slow server too. 30 db calls in a fraction of a second...
if you conditionally redirect them, maybe your condition is being met more than you planned it to be met.
maybe they got stuck in an infinite redirection, and the browser said no more after 30 redirects and showed a built in error page(IE is famous for that). that could cause a slow server too. 30 db calls in a fraction of a second...
after fighting with this for almost a week, I think I have finally figured out the problem.
Although I should not say "I" as this was a collaborative effort on 3 parts.
first off I need to thank Feyd for spending an inordinate amount of time with me on IM, Breeze, and the phone to try and figure this out...when I say inordinate, I mean several hours...big props to Feyd.
I also need to thank smpdawg for the same reason. He spent well over an hour with me today on Breeze working to find a solution. We troubleshot the living hell out of it and nothing ever reared its ugly head. Finally after dealing with my configuration, he suggested that we install apache and that was the problem...stupid IIS (thanks a lot Bill!!!).
both of you two went well above and beyond the call of duty to assist here and I can not thank either of you enough.
there is pie in your futures...
Burr
Although I should not say "I" as this was a collaborative effort on 3 parts.
first off I need to thank Feyd for spending an inordinate amount of time with me on IM, Breeze, and the phone to try and figure this out...when I say inordinate, I mean several hours...big props to Feyd.
I also need to thank smpdawg for the same reason. He spent well over an hour with me today on Breeze working to find a solution. We troubleshot the living hell out of it and nothing ever reared its ugly head. Finally after dealing with my configuration, he suggested that we install apache and that was the problem...stupid IIS (thanks a lot Bill!!!).
both of you two went well above and beyond the call of duty to assist here and I can not thank either of you enough.
there is pie in your futures...
Burr