php - Maximum SQL Queries per page -


There is no definitive answer to this question, so if it is considered subjective and assume that bad < / Em> Please feel free to turn it off.

Actually I'm developing a huge web application (PHP), and uses it. Right now it is under development and some things in the database are really complex, so there is a need to create many questions to display pages (about 7-25 questions).

Since this is likely to happen on a large scale, I would like to know what max is, it is a type of point which indicates that "you might be doing something wrong And should be optimized ", the number of SQL queries that should be per page. I have a very simple caching system that just reduces the queries run by 5 of the 15 seconds for the same user.

What are the 25 questions going on? Should I stop development for a short time (I have a lot of time) and stop the code refactor, remove SQL queries, which do not give time to improve performance on this part?

It may seem a bit confusing, then it has been started again: Is there a question that does not make a server (which is a shared hosting environment), went per page Maximum

The total number of hits in your database is similar to the number of page views. Therefore, if page is more than your database's ability to * page per question *, then you have a problem, obviously the traffic varies greatly on site site, as is the capacity of the database, so in fact for the purpose Number can not be


Comments

Popular posts from this blog

c# - sqlDecimal to decimal clr stored procedure Unable to cast object of type 'System.Data.SqlTypes.SqlDecimal' to type 'System.IConvertible' -

Calling GetGUIThreadInfo from Outlook VBA -

Obfuscating Python code? -