Received: from localhost (maia-4.hub.org [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id 1CC949FB7A8
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Thu, 31 May 2007 05:11:14 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 38477-03 for <pgsql-sql-postgresql.org@postgresql.org>;
	Thu, 31 May 2007 05:11:11 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.4
Received: from interscan.indicator.com (mail.indicator.be [193.121.199.3])
	by postgresql.org (Postfix) with ESMTP id AD9319FB75D
	for <pgsql-sql@postgresql.org>; Thu, 31 May 2007 05:11:10 -0300 (ADT)
Received: from webaccess.indicator.be ([10.100.1.7]) by
	interscan.indicator.com with InterScan Message Security Suite;
	Thu, 31 May 2007 09:56:22 +0200
Received: from DOMEXT-MTA by webaccess.indicator.bewith Novell_GroupWise;
	Thu, 31 May 2007 10:11:08 +0200
Message-Id: <465E9F36.A3DD.0030.0@indicator.be>
X-Mailer: Novell GroupWise Internet Agent 7.0.1 
Date: Thu, 31 May 2007 10:11:03 +0200
From: "Bart Degryse" <Bart.Degryse@indicator.be>
To: <pgsql-sql@postgresql.org>
Subject: Re: slow query execution
References: <116998.85849.qm@web52711.mail.re2.yahoo.com>
In-Reply-To: <116998.85849.qm@web52711.mail.re2.yahoo.com>
Mime-Version: 1.0
Content-Type: multipart/alternative;
	boundary="=__PartF4D3E107.0__="
X-imss-version: 2.047
X-imss-result: Passed
X-imss-approveListMatch: *@indicator.be
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.509 tagged_above=0 required=5 tests=AWL=-0.125,
	BAYES_50=0.001, FORGED_RCVD_HELO=0.135, HTML_40_50=0.496,
	HTML_MESSAGE=0.001, UNPARSEABLE_RELAY=0.001
X-Spam-Level: 
X-Archive-Number: 200705/207
X-Sequence-Number: 28487

--=__PartF4D3E107.0__=
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: quoted-printable

Sorry, I don't know C++ enough to help you much. I also don't understand =
your problem well enough.=20

>>> 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 ineffectivewhen table has about 10.000+ records and user =
want to view/search only first 100 records.

thanks

Trigve


--=__PartF4D3E107.0__=
Content-Type: text/html; charset=US-ASCII
Content-Transfer-Encoding: quoted-printable
Content-Description: HTML

<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Diso-8859-15=
">
<META content=3D"MSHTML 6.00.2800.1264" name=3DGENERATOR></HEAD>
<BODY style=3D"MARGIN: 4px 4px 1px; FONT: 10pt Tahoma">
<DIV>Sorry, I don't know C++ enough to help you much. I also don't =
understand your problem well enough. <BR><BR>&gt;&gt;&gt; Trigve Siver =
&lt;trigves@yahoo.com&gt; 2007-05-31 9:46 &gt;&gt;&gt;<BR></DIV>
<DIV style=3D"FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, =
times, serif">
<DIV style=3D"FONT-SIZE: 12pt; FONT-FAMILY: times new roman,new york,times,=
serif">Hi, thanks for reply<BR><BR>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 <SPAN class=3Dvcb_lt>ineff=
ective</SPAN><SPAN class=3Dvcb_m> when table has about 10.000+ records and =
user want to view/search only first 100 records.<BR><BR>thanks<BR><BR>Trigv=
e<BR></SPAN><BR></DIV></DIV></BODY></HTML>

--=__PartF4D3E107.0__=--