I get multiple recordsets all the time. I much prefer to make one trip to the database server than multiple trips.
However, I dont make one single trip to the DB for an entire site. I still prefer to err on the side of maintainability and code procedures to only get similar data (for example, I wouldn't use a single procedure to get the detail of a bookstore item, the navigation of the site, and site-wide constants stored in the database). Does this apply to your specific circumstance.. well I'm not sure. Your idea sounds fine, but without knowing exactly how your database works, your goals, and how you want things to operate, it's hard to say. But is getting multiple SP recordsets a bad practice? No. You might also be able to use Query of Query to get a single big recordset from the DB and then QoQ to get only the records you need. Perhaps try both ways and see which performs better. Jeremy -----Original Message----- From: Schreck, Tom [mailto:[EMAIL PROTECTED]] Sent: Monday, January 07, 2002 12:12 PM To: [EMAIL PROTECTED] Subject: stored procedures 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 ------------------------------------------------------------------------- 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
