well, it is regarding best ways of creating SQL queries.Plz don't suggest ORM tools like Hibernate for this small project..
You know, i have to do a big query, kind of involves 12 tables,.. when a user submits a form. So i am just doing it in a single query, involving some Outer Joins and all; it takes quite some time.I do show "processing.. Please wait .. " page. Only one access to the database gets me the results from about 12 tables. Is this the best approach?? or do smaller but more number of queries??
Which is faster and more efficient??
Also i felt putting everything in one query, for making further changes, just changing that one query is good enough. If it is more than 1 query, you have to make changes everywhere, i mean all queries.
Just eager to listen to, what the JDBC gurus would say. Thanks I of-course use DataSource connection Pooling and only Prepared Statements. [ April 07, 2005: Message edited by: Bear Bibeault ]
It's usually better to do one big query than to, in effect, do joins in your application code. But a complicated, slow query like this one will take some work on your part to optimize. You'll need to add the right indexes, and you may need to prod the database a bit to get it to choose the best join order.