>My assumption would be that is the estimate of the number of seconds it 
will take the process to complete.

That's right.

On a very slow system - Apr-24-15 04:34:03 Rebuild processed 5.65 files 
per second.

ASSP and the MySQL DB running on the same system.

Spamdb takes 42 seconds (9220 records per second)

Apr-24-15 04:28:29 start populating Spamdb with 387,637 records - Bayesian 
check is now disabled!
Apr-24-15 04:29:11 Finished populating Spamdb with 387,637 records - 
Bayesian check is now enabled!
Apr-24-15 04:29:11 done - Generating weighted Bayesian tuplets 

HMMdb takes 140 seconds (10318 records per second)

Apr-24-15 04:31:42 Start populating Hidden Markov Model. HMM-check is 
disabled for this time!
Apr-24-15 04:31:43 start populating Hidden Markov Model with 1,444,532 
records!
Apr-24-15 04:34:03 Finished populating Hidden Markov Model with 1,444,532 
records!
Apr-24-15 04:34:03 Finished populating Hidden Markov Model. HMM-check is 
now enabled again! 

Thomas



Von:    Colin Waring <co...@dolphinict.co.uk>
An:     ASSP development mailing list <assp-test@lists.sourceforge.net>
Datum:  23.04.2015 17:50
Betreff:        Re: [Assp-test] speed of adding records to spamdb table



My assumption would be that is the estimate of the number of seconds it 
will take the process to complete.

Our rebuild takes about 10 seconds to populate the database, you do need 
to do some network tuning and make sure your database is optimised for 
purpose, I can't help you with MS SQL though.

All the best,
Colin Waring.

-----Original Message-----
From: K Post [mailto:nntp.p...@gmail.com] 
Sent: 23 April 2015 15:25
To: ASSP development mailing list
Subject: [Assp-test] speed of adding records to spamdb table

Working to get the rebuild process to complete.  Win32.  MS SQL DB.

Are these speeds normal??  I'm a little confused to the "sec" numbers, 
It's not 5,000+ seconds, I don't think. and I don't know why secs would be 
decreasing.  confused.

Apr-23-15 10:21:37 Added 176152 of 998035 records for table spamdb - 
finished in 5081 sec
Apr-23-15 10:21:38 Added 176346 of 998035 records for table spamdb - 
finished in 5078 sec
Apr-23-15 10:21:40 Added 176540 of 998035 records for table spamdb - 
finished in 5081 sec
Apr-23-15 10:21:42 Added 176928 of 998035 records for table spamdb - 
finished in 5077 sec
Apr-23-15 10:21:47 Added 177704 of 998035 records for table spamdb - 
finished in 5073 sec
Apr-23-15 10:21:48 Added 177785 of 998035 records for table spamdb - 
finished in 5075 sec
Apr-23-15 10:21:49 Added 177940 of 998035 records for table spamdb - 
finished in 5074 sec
Apr-23-15 10:21:53 Added 178560 of 998035 records for table spamdb - 
finished in 5071 sec
Apr-23-15 10:21:55 Added 178870 of 998035 records for table spamdb - 
finished in 5069 sec
Apr-23-15 10:21:57 Added 179180 of 998035 records for table spamdb - 
finished in 5068 sec
Apr-23-15 10:21:59 Added 179490 of 998035 records for table spamdb - 
finished in 5066 sec
Apr-23-15 10:22:01 Added 179800 of 998035 records for table spamdb - 
finished in 5065 sec
------------------------------------------------------------------------------
BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT Develop your 
own process in accordance with the BPMN 2 standard Learn Process modeling 
best practices with Bonita BPM through live exercises
http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- 
event?utm_ 
source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF
_______________________________________________
Assp-test mailing list
Assp-test@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/assp-test




------------------------------------------------------------------------------
BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
Develop your own process in accordance with the BPMN 2 standard
Learn Process modeling best practices with Bonita BPM through live 
exercises
http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- 
event?utm_
source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF
_______________________________________________
Assp-test mailing list
Assp-test@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/assp-test






DISCLAIMER:
*******************************************************
This email and any files transmitted with it may be confidential, legally 
privileged and protected in law and are intended solely for the use of the 

individual to whom it is addressed.
This email was multiple times scanned for viruses. There should be no 
known virus in this email!
*******************************************************

------------------------------------------------------------------------------
One dashboard for servers and applications across Physical-Virtual-Cloud 
Widest out-of-the-box monitoring support with 50+ applications
Performance metrics, stats and reports that give you Actionable Insights
Deep dive visibility with transaction tracing using APM Insight.
http://ad.doubleclick.net/ddm/clk/290420510;117567292;y
_______________________________________________
Assp-test mailing list
Assp-test@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/assp-test

Reply via email to