I understand cfstoredproc will return multiple recordsets from a stored procedure. Is this good practice? What are the performance issues? We have a navigational structure that's cumbersome. I need to re-write it. There are 5 different navigation menu items whose menu items are dynamic per user. I'm thinking 1 stored proc that will return the nav items for each menu in seperate recordsets. All I pass in is the person's unique identifier. So, another way to look at this is the multiple recordsets returned would be equivalent to running the individual queries? Seems this would be much more efficient.
Thanks - Tom ------------------------------------------------------------------------- This email server is running an evaluation copy of the MailShield anti- spam software. Please contact your email administrator if you have any questions about this message. MailShield product info: www.mailshield.com ----------------------------------------------- To post, send email to [EMAIL PROTECTED] To subscribe / unsubscribe: http://www.dfwcfug.org
