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.

I was actually surprised because I thought I seen some claims of much faster performance with 10.3 server.

I was getting around 1,630 transactions per second (each transaction is a VALUES 1 statement) on a 100Mbit network.

Did anyone make changes in 10.3 that they think would make this simple test improve, or is anyone working on reducing the basic overhead for client server? Are the nio changes intended to improve performance?

Thanks,
Dan.

Reply via email to