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