From: Andrew Sullivan <ajs@crankycanuck.ca>
To: pgsql-sql@postgresql.org
Subject: Re: slow query execution
Date: Wed, 30 May 2007 14:30:32 -0400
Message-ID: <20070530183032.GP16260@phlogiston.dyndns.org> (raw)
In-Reply-To: <210031.38017.qm@web52704.mail.re2.yahoo.com>
References: <210031.38017.qm@web52704.mail.re2.yahoo.com>
On Wed, May 30, 2007 at 11:08:02AM -0700, Trigve Siver wrote:
> I want to do it only for some queries. So when I need query like
> that "SELECT * from t1" I need to add row_numbers there. So I will
> have "query with row_numbers" (where row_numbers are row numbers of
> my virtual list view). Then when I perform search I also get
> row_numbers for IDs of search result and I can highlight items in
> my list view. I haven't found other solution that met my
> requirements.
You really need to ensure you keep that ORDER BY in there, then. The
order that SQL returns in is not determined until the data has come
back. Are you doing this all in one serialisable transaction,
though? If not, what guarantee will you have that new data won't
mess up your row numbering from query to query?
A
--
Andrew Sullivan | ajs@crankycanuck.ca
The plural of anecdote is not data.
--Roger Brinner
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: ajs@crankycanuck.ca
Subject: Re: slow query execution
In-Reply-To: <20070530183032.GP16260@phlogiston.dyndns.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