Re: slow query execution

From: "Bart Degryse" <Bart(dot)Degryse(at)indicator(dot)be>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Re: slow query execution
Date: 2007-05-31 08:11:03
Message-ID: 465E9F36.A3DD.0030.0@indicator.be
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)yahoo(dot)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 ineffectivewhen table has about 10.000+ records and user want to view/search only first 100 records.

thanks

Trigve

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Trigve Siver 2007-05-31 08:42:00 Re: slow query execution
Previous Message Phillip Smith 2007-05-31 08:02:58 Re: ASK about SQL