Benchmark: timing 500 iterations of Way1A, Way2A, Way2B, Way3A, Way4A, Way4B, Way5A, Way5B, Way6A... Way1A: 48 wallclock secs ( 0.52 usr + 0.16 sys = 0.68 CPU) @ 734.21/s (n=500) Way2A: 26 wallclock secs ( 0.75 usr + 0.03 sys = 0.78 CPU) @ 640.20/s (n=500) Way2B: 29 wallclock secs ( 0.69 usr + 0.08 sys = 0.77 CPU) @ 648.51/s (n=500) Way3A: 5 wallclock secs ( 0.52 usr + 0.04 sys = 0.56 CPU) @ 891.27/s (n=500) Way4A: 3 wallclock secs ( 0.58 usr + 0.05 sys = 0.63 CPU) @ 792.39/s (n=500) Way4B: 3 wallclock secs ( 0.72 usr + 0.09 sys = 0.81 CPU) @ 616.52/s (n=500) Way5A: 28 wallclock secs ( 0.50 usr + 0.05 sys = 0.55 CPU) @ 907.44/s (n=500) Way5B: 30 wallclock secs ( 0.56 usr + 0.04 sys = 0.60 CPU) @ 833.33/s (n=500) Way6A: 61 wallclock secs ( 0.62 usr + 0.15 sys = 0.77 CPU) @ 647.67/s (n=500) Rate Way4B Way2A Way6A Way2B Way1A Way4A Way5B Way3A Way5A Way4B 617/s -- -4% -5% -5% -16% -22% -26% -31% -32% Way2A 640/s 4% -- -1% -1% -13% -19% -23% -28% -29% Way6A 648/s 5% 1% -- -0% -12% -18% -22% -27% -29% Way2B 649/s 5% 1% 0% -- -12% -18% -22% -27% -29% Way1A 734/s 19% 15% 13% 13% -- -7% -12% -18% -19% Way4A 792/s 29% 24% 22% 22% 8% -- -5% -11% -13% Way5B 833/s 35% 30% 29% 29% 14% 5% -- -6% -8% Way3A 891/s 45% 39% 38% 37% 21% 12% 7% -- -2% Way5A 907/s 47% 42% 40% 40% 24% 15% 9% 2% -- Sybase performance values: Engine Busy Utilization Engine 0 6.2 % Inserts APL Heap Table 7875 Total Lock Requests 84663