Received: from marketingchallenge.com (marketingchallenge.com [64.40.111.205] (may be forged)) by postgresql.org (8.11.3/8.11.1) with SMTP id f3JG1Wu79434 for ; Thu, 19 Apr 2001 12:01:32 -0400 (EDT) (envelope-from drfrog@smartt.com) Received: (qmail 24179 invoked from network); 19 Apr 2001 16:01:30 -0000 Received: from clayton-cottingham.imc (HELO smartt.com) (drfrog@10.1.4.1) by marketingchallenge.com with SMTP; 19 Apr 2001 16:01:30 -0000 Message-ID: <3ADF0BDF.45092C88@smartt.com> Date: Thu, 19 Apr 2001 09:01:35 -0700 From: clayton cottingham X-Mailer: Mozilla 4.76 [en] (X11; U; Linux 2.2.17-21mdk i686) X-Accept-Language: en MIME-Version: 1.0 To: Justin Clift CC: pgsql-sql@postgresql.org Subject: Re: any proper benchmark scripts? References: <3ADC8D97.23D5E339@smartt.com> <200104190209.f3J29Yj06260@smartt.com> <3ADEBAC0.8D7B4E6F@postgresql.org> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200104/330 X-Sequence-Number: 2686 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!!