Include a "Limit" in your query.
Michael Schmidt
Sorry. Forgot the link:
http://www.onjava.com/pub/a/onjava/2004/06/16/dbcancel.html?page=2
"William ZHANG" <[EMAIL PROTECTED]>
> Re: [GENERAL] partial resultset in javaI have not install pgsql's jdbc.
> But I think the following link may help.
>
> Regards,
> William ZHANG
>
-
Re: [GENERAL] partial resultset in javaI have not install pgsql's jdbc. But
I think the following link may help.
Regards,
William ZHANG
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgres
Title: Re: [GENERAL] partial resultset in java
on which object is this method "cancel()" avaialble.
the peice of code that i am looking at right now is :
Statement stmt_ =
this.dbSession_.getDBConnection().createStatement();String queryStr =
dbxQuery.createQuery(DBObject.getL
In article <[EMAIL PROTECTED]>,
Luckys <[EMAIL PROTECTED]> writes:
> I believe you should restrict number of rows that needs to be returned, or
> giving a choice to the user, although showing the total count. Even if you
> display all 20K records, no one is going to see them all, you can even add
There is a method called cancel() in interface Statement. But I don't know
if it is
implemented correctly in JDBC. Maybe you can try it.
Regards,
William ZHANG
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
rom: Luckys [mailto:[EMAIL PROTECTED]]Sent: Wed 3/22/2006 11:23 AM
To: Michael SchmidtCc: surabhi.ahuja; PostgreSQL GeneralSubject: Re: [GENERAL] partial resultset in java
***
Your mail has been scanned by InterScan VirusWall.
***-***
I believe you should re
2006 11:23 AMTo:
Michael SchmidtCc: surabhi.ahuja; PostgreSQL
GeneralSubject: Re: [GENERAL] partial resultset in
java
***
Your mail has been scanned by InterScan VirusWall.
***-***
I believe you should restrict number of rows that needs to be re
chael Schmidt
- Original Message -
From: surabhi.ahuja
To: pgsql-general@postgresql.org
Sent: Tuesday, March 21, 2006 8:53 PM
Subject: [GENERAL] partial resultset in java
hi,
i have a small question
I have a table, with one of the fields called x (x is not the primary key, here)
now i
From: surabhi.ahuja
To: pgsql-general@postgresql.org
Sent: Tuesday, March 21, 2006 8:53
PM
Subject: [GENERAL] partial resultset in
java
hi,
i have a small question
I have a table, with one of the fields called x
(x is not the primary key, here)
now i have to make a
hi,
i have a small question
I have a table, with one of the fields called x (x
is not the primary key, here)
now i have to make a query like this:
select * from table where x = 1;
the number of rows retrieved from the above query
is of the order of 20,000 or more.
the result is contained in
11 matches
Mail list logo
