Re: slow query execution - Mailing list pgsql-sql

From Bart Degryse
Subject Re: slow query execution
Date
Msg-id 465E9F36.A3DD.0030.0@indicator.be
Whole thread Raw
In response to Re: slow query execution  (Trigve Siver <trigves@yahoo.com>)
List pgsql-sql
Sorry, I don't know C++ enough to help you much. I also don't understand your problem well enough.

>>> Trigve Siver <trigves@yahoo.com> 2007-05-31 9:46 >>>
Hi, thanks for reply

No, I'm working with c++ and libpqxx (pgsql c++ binding). I'm using Win32 Listview control with LS_OWNERDATA style. I can use std::map to map row_number to ID field but then I must fetch all records from that table. This could be ineffective when table has about 10.000+ records and user want to view/search only first 100 records.

thanks

Trigve

pgsql-sql by date:

Previous
From: "Phillip Smith"
Date:
Subject: Re: ASK about SQL
Next
From: Trigve Siver
Date:
Subject: Re: slow query execution