pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Paul Tomblin <ptomblin@xcski.com>
To: pgsql-general@postgresql.org
Subject: Help me speed things up...
Date: Wed, 6 Jun 2001 22:26:01 -0400
Message-ID: <20010606222601.A7733@allhats.xcski.com> (raw)
In-Reply-To: <6630.991879552@sss.pgh.pa.us>
References: <20010607010814.72573.qmail@web10005.mail.yahoo.com>
	<6630.991879552@sss.pgh.pa.us>

I'm doing some postgres stuff in perl.  I haven't done much database stuff
in many years, and back then I was doing Oracle in C.  I'm doing a major
query that gets a bunch of fields including a key, and then does other
queries with that key on other tables.  Now with Oracle I would have set
up and compiled a query for the subqueries, and then only substituted in
the key variable and do the query, and repeat ad-nauseum.  (Forgive the
fact that I've forgotten the terminology)  There doesn't seem to be any
way to do that in Pg.pm, unless I'm missing something, and my subqueries
are making the whole thing slow as molasses.  I think the query I just did
took about 45 minutes when I did the subqueries, and about 30 seconds
without.

-- 
Paul Tomblin <ptomblin@xcski.com>, not speaking for anybody
"But I heard him exclaim, as he climbed in the night
Merry Christmas to all, I have traffic in sight" - Phyllis Moses



view thread (2+ messages)  latest in thread

Message-ID: <20010606222601.A7733@allhats.xcski.com>
Permalink:  ../20010606222601.A7733@allhats.xcski.com/
Also on:    postgresql.org/message-id/20010606222601.A7733@allhats.xcski.com

 · 

reply

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 using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: ptomblin@xcski.com, pgsql-general@postgresql.org
  Subject: Re: Help me speed things up...
  In-Reply-To: <20010606222601.A7733@allhats.xcski.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