Benchmark: timing 500 iterations of Way1A, Way2A, Way2B, Way3A, Way4A, Way4B, Way5A, Way5B, Way6A... Way1A: 82 wallclock secs ( 0.55 usr + 0.17 sys = 0.72 CPU) @ 693.48/s (n=500) Way2A: 48 wallclock secs ( 0.62 usr + 0.10 sys = 0.72 CPU) @ 693.48/s (n=500) Way2B: 52 wallclock secs ( 0.57 usr + 0.04 sys = 0.61 CPU) @ 818.33/s (n=500) Way3A: 78 wallclock secs ( 0.55 usr + 0.11 sys = 0.66 CPU) @ 756.43/s (n=500) Way4A: 52 wallclock secs ( 0.60 usr + 0.05 sys = 0.65 CPU) @ 768.05/s (n=500) Way4B: 53 wallclock secs ( 0.61 usr + 0.09 sys = 0.70 CPU) @ 714.29/s (n=500) Way5A: 52 wallclock secs ( 0.51 usr + 0.06 sys = 0.57 CPU) @ 874.13/s (n=500) Way5B: 45 wallclock secs ( 0.39 usr + 0.09 sys = 0.48 CPU) @ 1039.50/s (n=500) Way6A: 70 wallclock secs ( 0.61 usr + 0.15 sys = 0.76 CPU) @ 657.03/s (n=500) Rate Way6A Way2A Way1A Way4B Way3A Way4A Way2B Way5A Way5B Way6A 657/s -- -5% -5% -8% -13% -14% -20% -25% -37% Way2A 693/s 6% -- -0% -3% -8% -10% -15% -21% -33% Way1A 693/s 6% 0% -- -3% -8% -10% -15% -21% -33% Way4B 714/s 9% 3% 3% -- -6% -7% -13% -18% -31% Way3A 756/s 15% 9% 9% 6% -- -2% -8% -13% -27% Way4A 768/s 17% 11% 11% 8% 2% -- -6% -12% -26% Way2B 818/s 25% 18% 18% 15% 8% 7% -- -6% -21% Way5A 874/s 33% 26% 26% 22% 16% 14% 7% -- -16% Way5B 1040/s 58% 50% 50% 46% 37% 35% 27% 19% -- Sybase performance values: Engine Busy Utilization Engine 0 34.4 % Inserts APL Heap Table 20250 Total Lock Requests 4331515