> 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

Reply via email to