That makes sense Colin. Time left, of course. Something's definitely not right, I'm guessing with the database: 10001 14784 s chkdb - finished (has been stuck running for last 4 hrs or so) Going to purge the DB and start over. Luckily this is pre-production.
On Thu, Apr 23, 2015 at 11:35 AM, Colin Waring <co...@dolphinict.co.uk> wrote: > 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 > ------------------------------------------------------------------------------ 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
