| Lists: | pgsql-jdbc |
|---|
| From: | <LSanchez(at)ameritrade(dot)com> |
|---|---|
| To: | <pgsql-jdbc(at)postgresql(dot)org> |
| Cc: | <pgman(at)candle(dot)pha(dot)pa(dot)us> |
| Subject: | Java Test Harness |
| Date: | 2004-05-17 20:40:10 |
| Message-ID: | 2898C2526ECBEB448D434BA1F302790902E93CE8@scsdcmail1.ameritrade.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-jdbc |
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
| From: | Dave Cramer <pg(at)fastcrypt(dot)com> |
|---|---|
| To: | LSanchez(at)ameritrade(dot)com |
| Cc: | "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org>, pgman(at)candle(dot)pha(dot)pa(dot)us |
| Subject: | Re: Java Test Harness |
| Date: | 2004-05-21 11:12:12 |
| Message-ID: | 1085137932.1587.21.camel@localhost.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-jdbc |
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(at)ameritrade(dot)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