From: clayton cottingham <drfrog@smartt.com>
To: Justin Clift <justin@postgresql.org>
Cc: pgsql-sql@postgresql.org
Subject: Re: any proper benchmark scripts?
Date: Thu, 19 Apr 2001 09:01:35 -0700
Message-ID: <3ADF0BDF.45092C88@smartt.com> (raw)
References: <3ADC8D97.23D5E339@smartt.com>
<200104190209.f3J29Yj06260@smartt.com>
<3ADEBAC0.8D7B4E6F@postgresql.org>
Justin Clift wrote:
>
> Hi Clayton,
>
> Was it opening a new connection to the database every time, or did it
> open one connection each time and pump multiple queries through it?
>
> It would be a good things to develop your script and benchmark this both
> ways. Could become a useful tool for sizing both of these databases.
>
> Out of curiosity do you have access to other databases such as
> Interbase, Oracle, DB2, Informix, and so forth? The more it can connect
> to, the better people will be able to understand each one's strengths
> and weaknesses, in terms of Perl's DB access.
>
> Regards and best wishes,
>
> Justin Clift
>
ok i looked over the script and the connections are opened before for
loops and shuit down after for loops
i dont have access to any other db's
but another person on the modperl list said he would be try oracle
check out that thread its been going since monday?
perl.apache.org click through maillists and use mailarchive.com
search for 'fast db access'
thats the thread!!
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: drfrog@smartt.com, justin@postgresql.org
Subject: Re: any proper benchmark scripts?
In-Reply-To: <3ADF0BDF.45092C88@smartt.com>
References: <3ADC8D97.23D5E339@smartt.com> <200104190209.f3J29Yj06260@smartt.com> <3ADEBAC0.8D7B4E6F@postgresql.org> <3ADF0BDF.45092C88@smartt.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox