Re: [Summary-Talk] Outgrown

[Jason Linhart <jason@xxxxxxxxxxx>]

On 4/26/04 11:21 AM Greg Swallow (gswallow@www.IN.gov) wrote:

>I believe we've outgrown our current version of summary again.  What are 
>the performance benefits to upgrading to Summary SP 2.5?

Summary 2.5 is a little faster, though the improvement is only noticeable 
in some configurations. Summary 2.5 requires slightly more memory, 
because it reports on more things. Since memory is probably your primary 
issue this might actually make things worse, until you get your memory 
usage under control.

>After generating 194 subreports for a website that sees 30.x million 
>accesses (page hits + downloads) per month, the "database" has grown to 
>1.35GB in size.
>I have 1GB RAM and lots of disk space.

It is *critical* that you have at least as much RAM as the size of 
Summary's database. Summary can slow down *very* dramatically if it 
starts swapping to virtual memory. There are various things you can do to 
reduce the size of the database, or you can purchase more RAM. We have a 
FAQ about this at <http://summary.net/manual/faq.html#memorylack>. There 
are several things described there that can get your memory usage under 
control.

>Will 2.5 help because it's more efficient, or is it time to start 
>thinking of a new stats system with a SQL backend?

Adjusting some settings on the memory configuration page should take care 
of it. Summary 2.5 does have a few new options for keeping memory usage 
under control, but the setting in 2.3.12 should be sufficient. Using an 
SQL database would be at least 1000 times slower.

Jason

-----------------
Jason@Summary.Net
-----------------
Dr. Seuss books . . . can be read and enjoyed on several levels. For
example, 'One Fish Two Fish, Red Fish Blue Fish' can be deconstructed
as a searing indictment of the narrow-minded binary counting system.
  -- Peter van der Linden, Expert C Programming, Deep C Secrets
-------------
Go to <http://summary.net/list.html> to update subscription info.