Re: validation testing -- use TPC-C? (or what?)

"z" <z_at_y.x.invalid> wrote in message
news:6OBnf.37054$tV6.22163_at_newssvr27.news.prodigy.net...
> How can validation testing on DBMSs such as DB2 and Oracle be performed?
>
> Is there a quick commonly used publicly available DBMS test that can be
> used?
>
> Could TPC-C be used? If so, where can TPC-C be obtained? (Is is publicly
> available?)

If you want to validate a database for use in your business environment, the best thing to do is build a simple prototype of your business app and test it on the databases you're considering. Both DB2 and Oracle come in "express" editions, and should be full-featured enough to put a prototype through it's paces. This way you can play with performance scaling, various DDL options, backup/restore and other things that you're bound to do when in production, and really get a feel for what works best in the intended environment.

To echo someone else's comments -- using an off-the-shelf benchmark (such as any of the TPC benchmarks) may not be anywhere near close to what your business needs are, and thus you'd end up with something that isn't a good fit. It's much like deciding to buy a sports car because it was the fastest and flashiest, and then finding out that your wife is pregnant with triplets and you should have bought a mini-van :)

--
Matt Emmerton