Thread: Java Test Harness

Hi Lily,

We haven't done any of this yet, but I'm certainly interested in it. I
may be interested in helping. Contact me off list, if you want. If
nothing else I can be a second set of eyes on the code.

Dave
On Mon, 2004-05-17 at 16:40, LSanchez@ameritrade.com wrote:
> Good afternoon!
>
>
>
> I’m Lily Anne Sanchez, a database engineer here at Ameritrade
> Holdings, Inc. I’m currently in charge of an initiative to evaluate
> postgresSQL for an eventual migration from Oracle and other enterprise
> rdbms. As part of our generic testing (benchmarking) phase, we are in
> the process of writing a java test harness that will do the following:
>
> - connect to any db specified in a config file via JDBC (and ODBC)
>
> - generate multiple connections, as specified in a config file,
> running on different threads
>
> - run a cobination of SQL select, insert, update, delete, sp
> statements, as specified in a config file
>
> - measure the throughput and outputs to a file that could be imported
> to a table for further analysis
>
>
>
> I was advised by Bruce Momjian to send you guys an email to see
> whether you’ve already done something like this, so as to compare our
> results and/or minimize the effort that we will need to do to complete
> this phase.
>
>
>
> Any help or advise that you could extend will be greatly appreciated.
>
>
>
> Thanks so much!
>
>
>
> Regards,
>
> - Lily Anne Sanchez
>
> 201.761.5905
>
>
>
>
>
>
> !DSPAM:40ad8f7e120572064719962!
--
Dave Cramer
519 939 0336
ICQ # 14675561