Hello, I need to log SQL executed by my application. The application uses Oracle ODP.NET ADO.Net provider, which doesn't support any easy mechanism for SQL logging. All the classes are (OracleConnection, OracleCommand) are also *sealed* so there was no other option than proxying/wrapping them. I implemented the logging logic using Castle Dynamic Proxy using this code: https://gist.github.com/Buthrakaur/b1124c08f8521f39f8fd . The only drawback is the performance overhead of this solution. It looks like the proxy-generation algorithm adds almost 100% to the execution time when I use some dummy SQL (select sysdate from dual) and "null" SQL logger (no logging overhead).
Did I make some mistake in my Dynamic proxy code (https://gist.github.com/Buthrakaur/b1124c08f8521f39f8fd) or is this just the best performance result I could get from this scenario? Thanks in advance for any performance hints. -- You received this message because you are subscribed to the Google Groups "Castle Project Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/castle-project-users. For more options, visit https://groups.google.com/d/optout.
