aspose file tools*
The moose likes JDBC and the fly likes Limiting the Fetch Size Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Limiting the Fetch Size" Watch "Limiting the Fetch Size" New topic
Author

Limiting the Fetch Size

Ram Chhabra
Ranch Hand

Joined: Jan 07, 2008
Posts: 48
Hi,

I need to check that does something exist in some specified table or not. For that i can run query like ... but my problem is that mytable consist 10 Lakhs of records.

I only need to check that is any single record exist or not.... Can i use setFetchSize() or something else... can you please suggest what policy should i opt to improve performance

Thanks
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

Why not limit your results set by specifying conditions in a where or having clause?

(also, what's a Lakh?)


JavaRanch FAQ HowToAskQuestionsOnJavaRanch
Ram Chhabra
Ranch Hand

Joined: Jan 07, 2008
Posts: 48
Thanks for your answer. After putting where clause also i am having 1 million of records. Then how to restrict.
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

How about choosing conditions that limit your result set to a smaller size?
Campbell Ritchie
Sheriff

Joined: Oct 13, 2005
Posts: 38405
    
  23
If I remember correctly lakh = 100,000.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Limiting the Fetch Size