07-29-2003, 04:17 PM
|
|
Junior Member
|
|
Join Date: Oct 2002
Location: France
Posts: 85
|
|
|
Number of SQL query
Hello everyone 
I have post this message on nukecops and I think it's really important, I post it here too and on portedmods.
|
Originally Posted by breakolami
|
Hello
I think there is too much SQL query in phpnuke and I'm searching how to reduce this.
For example, I just install phpnuke 6.6 on local machine.
See below SQL query for each page :- Homepage with news module by defaut and one article test :154 query
- Story Archives : 106 query
- Review : 109 query
- Feedback : 143 query
- Content with one test page : 111 query
- Encyclopedia (empty) : 108 query
- Addon_sample : 143 query
- FAQ (empty) : 106 query
- Forums (index) : 129 query
- Journal : 121 query
- Web Links (empty) : 143 query
- Members List : 124 query
- Private Messages : 135 query
- Submit News : 110 query
- Search : 112 query
- Recommand Us : 107 query
- Sections (empty) : 107 query
- Surveys : 120 query
- Statistics (index) : 123 query
- Detailled Statistics : 141 query
- Topics : 110 query
- Downloads (empty) : 145 query
- Top : 130 query
- Your Account (index) : 134 query
- Webmail (index) : 128 query
Total query : 2945
A member visit each page one time make 2945 query.
500 visit a day viewing each page one time : 1472500 query
It is really too much.
I think it is time to think about this.
I can't solve this problem but Nukecops team with help from Fransisco Burzi..........................
Here, in France there his some web host limit SQL query for a day, for example my host limit to 45000 query per day.
Friendly
|
|
Linear Mode
