pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Albert Cervera Areny <albertca@jazzfree.com>
To: pgsql-performance@postgresql.org
Subject: Fwd: Stock update like application
Date: Sat, 4 Jan 2003 14:31:51 +0100
Message-ID: <200301041431.51423.albertca@jazzfree.com> (raw)

Hi!
  I'm developing a small application which I'd like to be as fast as
 possible. The program simply receives an order by modem and has to give an
 answer with the products my enterprise will be able to send them. The number
 of products could be as much as 300-400 and I don't want to make my clients
 put I high time-out before the answer is sended.

I do also need to use transactions as I start calculating before the whole
order has been received and if an error occurs everything has to be rolled
back.

Under this circumstances which way do you think it would be faster?

- Make a sequence for each product (we're talking about 20000 available
products so I think it is very big but it might give a really fast answer).

- Using standard SQL queries: SELECT the product, and if there are enough
units UPDATE to decrease the number of available ones. (This one I suppose
it's not very fast as two queries need to be processed for each product).

- Using a CURSOR or something like this which I'm not used to but I've seen
 in the examples.

Should I have the queries saved in the database to encrease performance?

I hope I explained well enough :-) Thanks in advance!



Message-ID: <200301041431.51423.albertca@jazzfree.com>
Permalink:  ../200301041431.51423.albertca@jazzfree.com/
Also on:    postgresql.org/message-id/200301041431.51423.albertca@jazzfree.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 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-performance@postgresql.org
  Cc: albertca@jazzfree.com
  Subject: Re: Fwd: Stock update like application
  In-Reply-To: <200301041431.51423.albertca@jazzfree.com>
  References: <200301041431.51423.albertca@jazzfree.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