Zikula Community

• **unknown user**
  
  

  • Rank: Softmore
  • Registered: Mar 16, 2002
  • Last visit: Oct 21, 2009
  • Posts: 292

  Posted: Aug 26, 2004 - 09:41 AM

  Hey all, I am constantly battling high CPU loads on pnFlashGames.com. I have looked at the statistics output and I'd love to see that level of reporting for my site, but I'm concerned about adding something else to every page load. I know that is the only way to get that kind of detailed report, but does it come at a price?
  
  My question is, has this module been tested on high traffic sites yet? If so, has anyone watched for an increase in CPU usage? pnFlashGames has really gone up the last week. Most of the day today we were averaging 15 to 20 members online and 150 to 190 guests.
  
  Thanks guys!

  • 
  •  
• **unknown user**
  
  

  • Rank: Expert
  • Registered: Mar 16, 2002
  • Last visit: Oct 21, 2009
  • Posts: 1193

  Posted: Aug 27, 2004 - 07:52 AM

  Yes, statistics has been tested on sites getting 70,000 hits a day. A number of the changes included in v7 were a result of working with webmasters of high-traffic sites to improve statistics usability with large sites.
  
  statistics has always been faster than Stats and Referers modules, primarily because it only does 2 or 3 SQL queries per page. The Stats module does at least twice that. In addition, if you have Referers turned on, you'll have more SQL queries being executed. So, if you have a high traffic site, do yourself a favor - install statistics and turn off Stats and Referers.
  
  There were 2 areas that we cleaned up in statistics v7 that is relevant to large sites:
  
  * We improved the performance of most reports. Some were poorly coded and just needed better SQL queries. But we also improved the performance of all reports by adding indexes on all the statistics tables. So if you're reporting on a lot of data, you don't have to wait until tomorrow for your report to finish.
  
  * We completed support of the multiple statistics tables. Now, you can run reports on any of the 3 statistics tables (details, summary, archive). And you can now move or copy data between any of the tables. This is useful for high-traffic sites so that you can keep the details table small to minimize the amount of time needed to collect and insert the visitor statistics into the details table. Just move the details data to one of the other tables and run your reports on that table.
  
  
  But, if you're concerned about the effect of statistics on your performance, just install it. If you think that it's causing a problem, all you have to do is go into Admin -> statistics -> Parameter Configuration and uncheck the "Collect statistics?" check box and statistics will stop collecting...

  • 
  •  
• **unknown user**
  
  

  • Rank: Softmore
  • Registered: Mar 16, 2002
  • Last visit: Jun 26, 2009
  • Posts: 201

  Posted: Aug 28, 2004 - 12:07 AM

  Hi leason
  some games need more time to finish,they already loged out when some users finish them,and their score cann't be recorded.
  so i increase the session live time,But the online numbers are terrible!
  Is there some good method ?

  • 
  •  
•  
•  

Users on-line

• mesteele101

This list is based on users active over the last 60 minutes.