From: | Andrew Sullivan <ajs(at)crankycanuck(dot)ca> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: slow query execution |
Date: | 2007-05-30 18:30:32 |
Message-ID: | 20070530183032.GP16260@phlogiston.dyndns.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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(at)crankycanuck(dot)ca
The plural of anecdote is not data.
--Roger Brinner
From | Date | Subject | |
---|---|---|---|
Next Message | Trigve Siver | 2007-05-30 18:55:05 | Re: slow query execution |
Previous Message | Trigve Siver | 2007-05-30 18:08:02 | Re: slow query execution |