Andreas,
Since you asked, I am talking about a specialized version of DBAppender which I have *not* published because it uses advanced JDBC features unavailable on most JDBC drivers. Actually, it is supposed to work only with the most recent version of the MySQL JDBC connector. (On older JDBC connectors there were problems.) The idea is to buffer the events and spit them out in batches. This results in a huge boost in performance. However, I currently do not have the time to consolidate the code as there are much more urgent items on my to do list.
At 04:21 AM 6/23/2004, Andreas Guther wrote:
Ceki:
Is this a specific (MySQL) DBAppender you are talking about?
Andreas
Ceki G�lc� wrote:
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,
--------------------------------------------------------------------- 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]
