We recently upgraded to EclipseLink from TopLink and noticed a huge
performance drop on MSSQL Server. Our automated test suite went from
taking
8 minutes to about 25 minutes. Oracle and MySQL didn't seem to have the
same problem. We aren't currently running our application with
bindAllParameters set to true because of a performance problem we
documented
in the following forum post.
On a hunch, I turned bindAllParameters to true, and reran the test suite.
The MSSQL Server performance was back down to 8 minutes or so. I expect
parameterized statements to be faster in general, but I'm a little hesitant
to turn them back on in our production environment given the trouble we had
with the above problem. Also, I'm wondering why would EclipseLink
performance on non-parameterized statements be so much worse? Does anyone
have any input here? If there was a bug fix for the performance problem,
I'm hoping someone here would know.