This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes JDBC and the fly likes need advice Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "need advice" Watch "need advice" New topic
Author

need advice

Ishita Saha
Ranch Hand

Joined: May 30, 2007
Posts: 39
Hi,

I have an application which is just a reporting tool so it just queries a database and fetches a plenty of records.
The database is quite heavy and it takes a significant amount of time for my code to fetch records and display.

To make the situation worse - there are a no of different criterias for the queries based upon different combination of the columns in the table.

my question is that as of now for every combination of criteria i am having a seperate query. is there any other way so that i don't end up with having 100 queries in my code.
sridhar vedhanabatla
Greenhorn

Joined: Feb 21, 2007
Posts: 12
U hav specified vague info. Infact the way query can be written lot depends on the nature of the data, how database has been designed etc.

Normally data that is spread across many tables can n retrieved using joins. You may have to use joins and some stored procedures to filter data.

In either case you will have to decide based on the what data out of large set do you want?

So the next time you post give specific details of the nature of data and the datbase design so that one can help you specific to issue.
Stan James
(instanceof Sidekick)
Ranch Hand

Joined: Jan 29, 2003
Posts: 8791
Can you build a SQL statement as a String with parts based on your criteria?

Or even better, build ? into your SQL statement and use a prepared statement.


A good question is never answered. It is not a bolt to be tightened into place but a seed to be planted and to bear more seed toward the hope of greening the landscape of the idea. John Ciardi
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: need advice
 
Similar Threads
Is data validation necessary?
how to show records in jsp
B&S create method
paging with mysql and java
How to track the Actions of WebSphere