pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Dan Langille <dan@langille.org>
To: pgsql-sql@postgresql.org
Subject: processing faster with plpgsql by passing in more data
Date: Mon, 25 Feb 2002 00:30:59 -0500
Message-ID: <200202250531.g1P5V3k60758@lists.unixathome.org> (raw)

The appliction involves passing a list of strings to the database and 
retrieving the results associated with those strings.  If done one at a 
time, I can process about 6 or 7 strings a second.  But I may have up to 
300 or 400 strings.  I don't want the user to sit around waiting that long 
and I'm looking for ways to speed this process up.

At present, the user uploads a file to the webserver via each string is 
passed to the database one at a time and the result fetch back.

I was thinking of passing in all the strings, getting the result set 
together and passing back all the results as a single result set, one for 
each string passed in.

Comments?  Ideas?

cheers
-- 
Dan Langille
The FreeBSD Diary - http://freebsddiary.org/ - practical examples




Message-ID: <200202250531.g1P5V3k60758@lists.unixathome.org>
Permalink:  ../200202250531.g1P5V3k60758@lists.unixathome.org/
Also on:    postgresql.org/message-id/200202250531.g1P5V3k60758@lists.unixathome.org

 · 

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: dan@langille.org
  Subject: Re: processing faster with plpgsql by passing in more data
  In-Reply-To: <200202250531.g1P5V3k60758@lists.unixathome.org>

* 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