Subject Re: Re: Getting n number of rows from a table ...
Author Anand
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.
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.
approach would give me the best results in terms of speed as
well as

Thanks and Regards,

Anand S. Kashelkar

Do you Yahoo!?
New Yahoo! Photos - easier uploading and sharing.