Thanks for the tip. I was thinking along the lines of building a test suite app where the user can choose which database platforms he/she has, run tests on the throughput of SELECT statements fetching various numbers of rows ( i.e., first pass would get first 100, then second pass, first 200, then third pass, the first 400 - doubling each time until a certain point, say 1,600.), do the same for INSERTS, UPDATES, and DELETES. One item of caution would be that more databases they choose from, the longer the test has the potential to take. There could be network considerations to take into place. As you can see, this could end up being a pretty big deal. Maybe just start of simple, then advance it. I could just go on and on :rolleyes:
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon