Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql Interfaces Jdbc > Re: Query size?
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 3 of 5 Topic 1979 of 2064
Post > Topic >>

Re: Query size?

by ptomblin@[EMAIL PROTECTED] (Paul Tomblin) Jun 22, 2008 at 08:37 AM

imad wrote:
> Why dont you adopt a pro-active aproach here and append a LIMIT to
> every query you send to the server?
> You can do an OFFSET LIMIT combination of all queries until you get
> results less than LIMIT.

What I'm asking though is if there is some way to know before I start 
returning results, short of doing a "COUNT(*)" first.


-- 
Paul Tomblin <ptomblin@[EMAIL PROTECTED]
> http://blog.xcski.com/
We're the technical experts.  We were hired so that management could
ignore our recommendations and tell us how to do our jobs.
               -- Mike Andrews

-- 
Sent via pgsql-jdbc mailing list (pgsql-jdbc@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-jdbc
 




 5 Posts in Topic:
Query size?
ptomblin@[EMAIL PROTECTED  2008-06-22 07:38:49 
Re: Query size?
immaad@[EMAIL PROTECTED]   2008-06-22 22:23:36 
Re: Query size?
ptomblin@[EMAIL PROTECTED  2008-06-22 08:37:29 
Re: Query size?
tgl@[EMAIL PROTECTED] (T  2008-06-22 14:56:18 
Re: Query size?
immaad@[EMAIL PROTECTED]   2008-06-22 22:55:02 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Mon Oct 13 2:23:29 CDT 2008.