Anton Shepelev
2020-09-17 22:22:02 UTC
Hello, all
I have an ADO.NET provider that performs some very slow and
redundant query processing. I can improve its performance in
my case by a factor of seven if I make it avoid the
stripping of comments form SQL code. At source level, it
means commenting a single invocation, but the assembly is
huge and compicated, and not easily decompiled. Is there a
way to "patch" the hacker way, wihout decompilation and re-
compilation, and replace the StripComments() comments with a
dummy implementation that does nothing and save huge amounts
of CPU time?
Funny that it should be the bottleneck in my data-migration
program, but I believe the profiler.
I have an ADO.NET provider that performs some very slow and
redundant query processing. I can improve its performance in
my case by a factor of seven if I make it avoid the
stripping of comments form SQL code. At source level, it
means commenting a single invocation, but the assembly is
huge and compicated, and not easily decompiled. Is there a
way to "patch" the hacker way, wihout decompilation and re-
compilation, and replace the StripComments() comments with a
dummy implementation that does nothing and save huge amounts
of CPU time?
Funny that it should be the bottleneck in my data-migration
program, but I believe the profiler.
--
() ascii ribbon campaign -- against html e-mail
/\ http://preview.tinyurl.com/qcy6mjc [archived]
() ascii ribbon campaign -- against html e-mail
/\ http://preview.tinyurl.com/qcy6mjc [archived]