> getting through. Each client connection does ~1500 lookups in the
> control
> table and another ~1500 inserts into the data table.
Have you tried a timing 100,000 simple INSERTs / SELECTs / UPDATEs
locally? Then you would have an approximate number for raw capability.
Then add a client connection. Then multiple connections. Then build up
to the clients queries.
Interesting question, Jeff