Re: Statistics from logfile to SQL

2005-12-15 Thread mouss
Matthew Yette a écrit : If you do large volumes of email, expect to have a table with millions upon millions of records, the w-illions of records take less space than the x-illions of messages to which they correspond. and slow access times :( and the access time will be less than that of:

Re: Statistics from logfile to SQL

2005-12-15 Thread Mike Jackson
If you do large volumes of email, expect to have a table with millions upon millions of records, and slow access times :( The altered script I'm using outputs spam/ham total summaries for each user, and spam/ham message hits for each rule. In a properly built database, that shouldn't be too t

Re: Statistics from logfile to SQL

2005-12-15 Thread Matthew Yette
If you do large volumes of email, expect to have a table with millions upon millions of records, and slow access times :( On 12/15/05 12:48 PM, "Mike Jackson" <[EMAIL PROTECTED]> wrote: >> I have been trying to find a script which would allow me to copy data >> from spamd logfile to MySQL databa

Re: Statistics from logfile to SQL

2005-12-15 Thread Mike Jackson
I have been trying to find a script which would allow me to copy data from spamd logfile to MySQL database. It would be usefull, since then I could provide datailed statistics to my users. Does anybody know a way to do it or I will just have to write a small script myself? Has anyone probably don

Statistics from logfile to SQL

2005-12-15 Thread Raimonds Aronietis
Dear all, I have been trying to find a script which would allow me to copy data from spamd logfile to MySQL database. It would be usefull, since then I could provide datailed statistics to my users. Does anybody know a way to do it or I will just have to write a small script myself? Has anyone pr