----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: MohangandhiC Message 5 in Discussion Hi, Since you just need to display and you are going to display in single stretch all the details. Definitely go for single store procedure. Join the tables and get whatever data u want to display. Select only the required columns while writing SQL statements (dont give select * ). And depends on the amount of data you have in your database u can think of creating View with all your joins and make it as indexed view by creating index on views. Have proper index on the columns which are used in "where" conditions. Creating multiple SPs and making multiple DB calls from the application is very costlier than having single SP with joins. DB operations are so light weight in this scenario. Go for single SP!!! Have a nice time. Bye MohanGandhi. C BDOTNET <[email protected]> wrote: New Message on BDOTNET Performance Reply Recommend Message 1 in Discussion From: Ambrose Hi All, In my application, I have to display list of users with different details like which company he is working, what are all the projects he worked and other related details. Do I have to get it in a single SP or do I have to get all these details with different SPs . Which one will be the best way to do it. Which approach will give a gain in performance. Please let me know your views. Thanks Anandraj.A. View other groups in this category. Cheers, MohanGandhi. C<o:p></o:p> Be a better Globetrotter. Get better travel answers from someone who knows. Yahoo! Answers - Check it out. ----------------------------------------------------------- To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. http://groups.msn.com/bdotnet/_emailsettings.msnw Need help? If you've forgotten your password, please go to Passport Member Services. http://groups.msn.com/_passportredir.msnw?ppmprop=help For other questions or feedback, go to our Contact Us page. http://groups.msn.com/contact If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. mailto:[EMAIL PROTECTED]
