Hi, I am testing git version of dspam with PostgreSQL 9.0 running on FreeBSD 8 (Dual core cpu, 4 GB memory)
I trained dspam with 110K spam and 50K ham mails. Now I have more than 7 million entry on dspam. dspam=# SELECT count(*) from dspam_token_data ; count --------- 7075311 (1 row) I vacuum and reindex database regularly. When I start the dspam, processing an email tooks 40-50 sec at the beginning than drops to 10sec. If I made this test with more powerful server(quad core cpu with 16GB memory). it takes 0.01 secs. I belive that the problem with the small server about large database entries. but I would like to get better performance on the small server as well. Any idea? Do you think that sqlite might be better then pgsql on this setup? or did I train dspam with alots of spam/ham? Thanks. ------------------------------------------------------------------------------ Enable your software for Intel(R) Active Management Technology to meet the growing manageability and security demands of your customers. Businesses are taking advantage of Intel(R) vPro (TM) technology - will your software be a part of the solution? Download the Intel(R) Manageability Checker today! http://p.sf.net/sfu/intel-dev2devmar _______________________________________________ Dspam-user mailing list Dspam-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspam-user
