Knut Anders Hatlen wrote:
Daniel John Debrunner wrote:
I ran a simple test of executing VALUES 1 using a prepared statement
over the network server in auto-commit mode. 10.3 seemed to be the
same performance as 10.2, maybe up to 4% slower. The 10.2 numbers for
me were consistent, but the 10.3 numbers seemed to vary from 96% to
100% of the 10.2 numbers.
Did you run the 10.3 tests with -noSecurityManager? It might be that the
security manager that is installed by default in 10.3 affects the
network server performance.
I had to because the network server didn't work with the security
manager and remote hosts. :-)
The security manager should not cause performance degradation during
steady state. This is because during steady state no methods should be
called that require security checks.
Dan.
