Hi all,
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 ]