The connection are held until assp stopps. They are checked every 120
seconds and renewed if not available. Firefox should have a connection
timeout of more than 3600 seconds.
I don't recommend the Firebird DB. The Perl DBD driver is incomplete
(missing some standard functions) and the DB seems to be too slow.
>Jul-18-12 06:29:20 [Worker_10001] Error: Invalid token
-Dynamic SQL Error
-SQL error code = -104
-Unexpected end of command - line 1, column 61
Has you installed the new assp_db_import.cfg file ?
>Jul-18-12 06:31:02 [Worker_10001] Added 648 of 116408 records for table
spamdb - finished in 18042 sec
Jul-18-12 06:31:04 [Worker_10001] Added 660 of 116408 records for table
spamdb - finished in 18063 sec
Yes - this is Firebird. 12 records in two seconds.
If a Firebird DB is accessed via the Firebird server (socket based) it is
much slower than BerkeleyDB. See the following benchmark.
First - 200.000 very short records are added (INSERT).
Second - 200.000 records are read (SELECT).
Benchmark: timing 200000 iterations of Insert Berkeley, Insert Firebird...
Insert Berkeley: -1 wallclock secs ( 0.42 usr + 0.02 sys = 0.44 CPU) @
457665.90/s (n=200000)
Insert Firebird: 26 wallclock secs ( 5.15 usr + 2.09 sys = 7.24 CPU) @
27631.94/s (n=200000)
Rate Insert Firebird Insert Berkeley
Insert Firebird 27632/s -- -94%
Insert Berkeley 457666/s 1556% --
Benchmark: timing 200000 iterations of Select Berkeley, Select Firebird...
Select Berkeley: 1 wallclock secs ( 0.16 usr + 0.00 sys = 0.16 CPU) @
1282051.28/s (n=200000)
(warning: too few iterations for a reliable count)
Select Firebird: 30 wallclock secs ( 9.20 usr + 2.56 sys = 11.76 CPU) @
17005.36/s (n=200000)
Rate Select Firebird Select Berkeley
Select Firebird 17005/s -- -99%
Select Berkeley 1282051/s 7439% --
The INSERT in to a BerkeleyDB is 15.5 times faster - the SELECT is 74.4
times faster than on Firebird.
Thomas
Von: "Daniel L. Miller" <dmil...@amfes.com>
An: assp-test@lists.sourceforge.net,
Datum: 18.07.2012 15:22
Betreff: [Assp-test] Firebird DB
Everything still working, but I see intermittent entries such as:
Jul-18-12 06:19:34 [Worker_10000] Warning: Worker_10000 - check the
database connections has taken 1.580 seconds (max=1.000s)
Jul-18-12 06:19:37 [Main_Thread] Warning: Main_Thread - check the
database connections has taken 1.968 seconds (max=1.000s)
Does ASSP open & close DB connections constantly? Or are connections
opened and then held open for an extended period?
--
Daniel
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
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!
*******************************************************
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Assp-test mailing list
Assp-test@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/assp-test
