My tests with DBAppender show that using pooled connections, it takes about 10 milliseconds to insert an event into a MySQL DB (of type *INNODB*) running locally. It still takes approx. 10 millis logging to a PostgreSQL DB running on a relatively old and slow Linux server (with pooled connections).
DBAppender is completely DB agnostic. It will run on all RDBMMSs. An optimized version of DBAppender (but which is MySQL-only) logs at 500 *microseconds* per event.
HTH,
At 02:27 PM 6/18/2004, you wrote:
I am also interested in that kind of information. I also started recently looking into logging into tables and would be interested in some performance results and experience reports in high volume environments.
Andreas
pooja wrote:
Hi All
I haven't received a response on this issue. Can someone at Log4j answer it for me?
Thanx
--- Pooja.
-----Original Message-----
From: pooja [mailto:[EMAIL PROTECTED] Sent: Monday, June 14, 2004 6:50 PM
To: 'Log4J Users List'
Subject: Database Logging Performance Numbers
Hello I am looking for some performance numbers for Database Logging. I want to be able to analyze/query my log records at a later date in multiple of ways. Hence Logging into database seems to be the perfect choice. But the system is a transactional system and it will be handling more than a million transactions a day. Hence making it necessary, that I first prove that Logging into Database will not hamper performance. Can someone provide some published numbers?
I will be fine with test cases as well; I'll run them against the current file logging system and get comparative figures. Currently, I am writing some crude test cases of my own. At the same time, if neone knows of some application (which handles so many transactions) already writing logs into database & functioning, this reference will suffice my job. Thanx --- Pooja.
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
-- Ceki G�lc�
For log4j documentation consider "The complete log4j manual"
ISBN: 2970036908 http://www.qos.ch/shop/products/clm_t.jsp
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
