> The statement is parsed only once, so you save the overhead of parsing > and doing an execution plan for each execution, which will be > identical. And I expect to insert hundreds of entries per second. :)
This is where more extensive database programming experience probably helps; I was unaware of (but understand the reason for) the additional overhead. Good to know. > context. So I'm looking here for the balance between rsyslog doing work > for me and rsyslog performing as good as I need it. Perhaps exposing the > structures is not a good idea, either. Perhaps you could [ab]use the fact that ppString is an array and do something like ommail does, using more than one string/template when using a custom subject. What I don't know off the top of my head is whether this would limit the number of different Oracle outputs you could connect to. RB _______________________________________________ rsyslog mailing list http://lists.adiscon.net/mailman/listinfo/rsyslog http://www.rsyslog.com

