On Mon, 2003-01-27 at 15:21, Chris Gamache wrote:
> BEGIN;
> LOCK TABLE queue IN EXCLUSIVE MODE;
> UPDATE queue
> set status=$$
> WHERE id = (SELECT min(id)
> FROM queue
> WHERE status=0);
This is unrelated, but note that the sub-select would probably be faster
written as:
SELECT id FROM queue WHERE status = 0 ORDER BY id ASC LIMIT 1;
As this form of the query can use a btree index on "id" if one's
present.
> SELECT id, data
> FROM queue
> WHERE status=$procid;
My Perl's a bit rusty, but AFAICS $procid is undefined. Perhaps 'perl
-w' and "use strict;" would be a good idea?
Cheers,
Neil
--
Neil Conway <neilc@samurai.com> || PGP Key ID: DB3C29FC
