<blockquote style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;" class="gmail_quote">
Anyone interested?!?<br></blockquote><div><br>yes, I am interested. <br><br>I think having the most common MDC keys like sessionId, requestId, remoteIP (well the list will be different for every app) in the same table as the event itself <br>
will drastically improve the throughput of the appender (one insert instead of 4).<br><br>It's on my TODO list, and it could be interesting to have a look at your solution.<br><br>regards,<br>Maarten<br>Â <br></div><br>
<div class="gmail_quote">On Thu, Feb 25, 2010 at 9:42 AM, Rü (JIRA) <span dir="ltr"><<a href="mailto:noreply-jira@qos.ch">noreply-jira@qos.ch</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<br>
  [ <a href="http://jira.qos.ch/browse/LBCLASSIC-169?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=11570#action_11570" target="_blank">http://jira.qos.ch/browse/LBCLASSIC-169?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=11570#action_11570</a> ]<br>
<br>
Rü commented on LBCLASSIC-169:<br>
<div class="im">------------------------------<br>
<br>
I actually have written a new database appender normalizing all the entities that are quite static: Level, Logger, and Marker.<br>
<br>
I've put the message and the arguments into separate columns, although that is not 100% clean, as I can now only store up to a fixed number of arguments (8 right now), which I currently consider a reasonable compromise.<br>
<br>
</div>I additionally normalized a session entity wich consists of the Thread name and the MDC... these don't change for a lot of log messages and it's nicer to have the together. Some special MDC values (node, slot, version, client, and reference) are stored into separate columns, the rest is stored into a map.<br>
<br>
Anyone interested?!?<br>
<div><div></div><div class="h5"><br>
> Customizing table names used by DbAppender<br>
> ------------------------------------------<br>
><br>
> Â Â Â Â Â Â Â Â Key: LBCLASSIC-169<br>
> Â Â Â Â Â Â Â Â URL: <a href="http://jira.qos.ch/browse/LBCLASSIC-169" target="_blank">http://jira.qos.ch/browse/LBCLASSIC-169</a><br>
> Â Â Â Â Â Â Project: logback-classic<br>
> Â Â Â Â Â Issue Type: Improvement<br>
> Â Â Â Â Â Components: appender<br>
> Â Â Affects Versions: 0.9.18<br>
> Â Â Â Â Â Â Reporter: Tomasz Nurkiewicz<br>
> Â Â Â Â Â Â Assignee: Ceki Gulcu<br>
> Â Â Â Â Â Â Priority: Minor<br>
><br>
> ch.qos.logback.classic.db.DBAppender uses hard-coded table names for logging events: logging_event, logging_event_property and logging_event_exception. Allowing to change these default names has two benefits:<br>
> * There are systems where database table names must follow some naming conventions (prefixes, using underscores vs. camel case)<br>
> * One could create several Db appenders, each operating on different set of tables (for performance reasons or more fine grained logging and filtering)<br>
> Each table name would be configured using a property in logback.xml. Default values for table names would be the same as present ones to maintain backward compatibility. If you are interested in this feature let me know, I can implement it and provide a patch.<br>
<br>
--<br>
This message is automatically generated by JIRA.<br>
-<br>
If you think it was sent incorrectly contact one of the administrators: <a href="http://jira.qos.ch/secure/Administrators.jspa" target="_blank">http://jira.qos.ch/secure/Administrators.jspa</a><br>
-<br>
For more information on JIRA, see: <a href="http://www.atlassian.com/software/jira" target="_blank">http://www.atlassian.com/software/jira</a><br>
<br>
<br>
_______________________________________________<br>
logback-dev mailing list<br>
<a href="mailto:logback-dev@qos.ch">logback-dev@qos.ch</a><br>
<a href="http://qos.ch/mailman/listinfo/logback-dev" target="_blank">http://qos.ch/mailman/listinfo/logback-dev</a><br>
</div></div></blockquote></div><br>