This topic is locked

Very slow application

9/9/2008 3:48:51 PM
PHPRunner General questions
G
gbhmayer1 author

My application is very slow. We have checked the Apache server and the mysql database but I think the problem is the code generated. Is there a way to make the application faster?

Sergey Kornilov admin 9/9/2008

What are your application specifics? What exactly works slow (search, update, delete)?
How many records you have in your tables? Are indexes in place?
You can post URL of your application here or send it to support@xlinesoft.com.

S
steveh 9/10/2008

Download a copy of wireshark on the client PC and sniff port 80, that will enable you to determine whether the issue is with the data being sent to the client from the server, or whether it's an issue on the server end.

If your server and database are on different servers you can also sniff that to see what queries are slow.

G
gbhmayer1 author 9/10/2008

I tested the connection to the database and found no problems. I tested the configuration of the Apache server and also not encountered problems. I noted, however, that an normal application in PHP developed without the use of smarty framework and ran faster than my application. Is there a way to optimize my application(developed with phpr)?

Sergey Kornilov admin 9/10/2008

I recommend to start by answering my questions.
We cannot help if you just saying "it works slow".

G
gbhmayer1 author 9/10/2008

Ok

it's an application for human resource management. Use MySQL with tables Innodb. The application is running normal locally but is slow when it is placed on the server Apache intranet. The application delay to replace the screens in all operations (search, adds, edits). I am sending a copy to support@linesoft.com.
Thank you.

G
gbhmayer1 author 9/11/2008

I solved the problem. The Apache server was in a machine different from the server mySQL. When you put everything on a single machine, the system started to run fast.

Sergey Kornilov admin 9/11/2008

Gersonbhm,
thank you for the update.
I suspected that was something related to network/web server configuration.