File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes need advice Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "need advice" Watch "need advice" New topic

need advice

Ishita Saha
Ranch Hand

Joined: May 30, 2007
Posts: 39

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

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:
subject: need advice
jQuery in Action, 3rd edition