[Summary-Talk] SQL?

[Greg Swallow <gswallow@xxxxxxxxxx>]

Hi,

I have a feature request.

We use Summary SP 2.3.13(? -- latest 2.3.x) on Linux.  With our 
increased popularity and some cache server implementation we're able to 
handle 30 million page hits + downloads per month, or about 300 million 
log lines, monthly.

We process stats monthly, overwriting the database each month, rather 
than going incremental, for obvious reasons.  Lately our database file 
has grown to 1.3GB in size, and it's causing serious problems for us -- 
stats take 4+ days to process log files and write static reports, 
crashes regularly, etc.  We have 1 GB of RAM -- to upgrade requires us 
to buy a new server.

I'm beginning to think that it's pointless to throw more hardware at 
this problem, which may or may not be due to the fact that summary's 
database is a file.  I'm also beginning to think that a SQL-based 
statistics package will be a lot more efficient.  Therefore, we're 
probably shopping around for a larger stats package very soon.

However, I personally love this software.  Are there any plans in the 
works to transfer Summary to Oracle/MySQL/MSSQL?  Would this be a 
reasonable feature request?

Thanks.

-- 
+--------------+------+----------------------+---------------+
| Greg Swallow | CCNA | System Administrator | accessIndiana |
+--(http://www.IN.gov/)----------------------(888.4IN.EGOV)--+

**********************************************************************
CONFIDENTIALITY NOTICE: This E-mail and any attachments are
confidential.  If you are not the intended recipient, you do not have
permission to disclose, copy, distribute, or open any attachments.
If you have received this E-mail in error, please notify us
immediately by returning it to the sender and delete this copy from
your system.

Thank you.
accessIndiana, MyLocal.IN.gov, CivicNet
**********************************************************************
-------------
Go to <http://summary.net/list.html> to update subscription info.