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
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