2. PHPRunner General questions
  3. [SOLVED]  Problems on Performance and users
This topic is locked
[SOLVED]

 Problems on Performance and users

 		10/5/2012 5:12:20 AM
PHPRunner General questions
S
 swanside author

Hello.
Just installed a new server SBS2011, since fitting and copying database and PHP project over, I have had the following problems.
Performance is really slow, about 30 sec's to display a list page with about 30 entries on it and the main thing is, If I login, then anybody else who is logged in is either logged out or it displays that they are logged in as me?
Now, in all fairness, I know its not really a PHPRunner issue, but, I was hoping that anybody else on here might have experienced the same or similar problems and can give me some guidance. The IT department have spent about £9.5k on this new server with UPS and its performing at about 30% of what the old server was running.

Cheers
Paul.
Sergey Kornilov admin 10/5/2012

There is something not right with server/network configuration. Are behind some sort of firewall/proxy server that makes all users look the same to the web server? Not sure what else it might be.
S
 		swanside author 10/5/2012



There is something not right with server/network configuration. Are behind some sort of firewall/proxy server that makes all users look the same to the web server? Not sure what else it might be.


Apparently, In the connection settings for the database, using Localhost slows it up.

When I used 127.0.0.1 it got a lot faster, plus, many can also connect to it now!
Might be worth remembering
S
 		swanside author 10/9/2012

Just an update.

I thought I solved this, but, I have not.
What I have found out now is, I have a job table and a contract table which is a child to the Job table, by Job_No and CustomerId
When in the contract table, the user selects Add New and enters the information and presses save.

The message comes up on the top saying the record has been saved and the options to edit or view.
If you do back to list and then do Add New again, the same message is at the top, and you can not add another input?
I know the software works, as I have put it on the demo account, and it runs OK, but, this blummin SBS2011 with IIS 7.5 is killing me now, so if anybody has any ideas, please do say
Regards

Paul.
S
 		swanside author 10/12/2012

Just so anybody else has a similar problem.
In the IIS7.5, company web and share point use port 80.
My solution was to create a new website in IIS manager and set it to a different port, like 83. Also, go into Output Caching for the new website and unstick User-mode caching. This stops the timeout for login and when adding new data into the database.
Dont forget to open the relative port in the firewall and router as well.
If anybody comes across this, please PM me, and I will do my best to help.
A
 		Abhijeet 10/17/2012

Hello,
As a Administrator, I would suggest you to use xampp for windows (if you are on windows, they have a linux version as well) instead of IIS and create a apache server. It is much more secured and works flawless even since first installation. If you are production system, you are advised to do it first on a development environment on windows and then give it a try in production environment. you will never repent I can assure you on this.
Hope this helps.
Abhijeet



Just so anybody else has a similar problem.
In the IIS7.5, company web and share point use port 80.
My solution was to create a new website in IIS manager and set it to a different port, like 83. Also, go into Output Caching for the new website and unstick User-mode caching. This stops the timeout for login and when adding new data into the database.
Dont forget to open the relative port in the firewall and router as well.
If anybody comes across this, please PM me, and I will do my best to help.