Thanks, Martijn, Florian and Horacio :)

I have a further question for optimizing the database
interaction. I need
to execute a query that fetches data from about 5-7 different
tables. I
could either create one big query that uses numerous JOINs and
other things,
and gives back one single resultset. Alternately I could break
up the task
into two or more queries and process them separately. For e.g.
first
getting the resultset for one query and then running another
query for this
resultset. Then I could either implement this setup using a
View or a
Stored Procedure or directly fire the query from my application.
Which
approach would give me the best results in terms of speed as
well as
maintenance?


Thanks and Regards,

Anand S. Kashelkar
Mumbai



__________________________________
Do you Yahoo!?
New Yahoo! Photos - easier uploading and sharing.
http://photos.yahoo.com/