Greetings, I've inherited an app and was wondering if I can make it better. It currently does a query to display data in a table. There is a main query run to get the info, then when it is displaying the data it runs other queries to get the names or descriptions to put into the table row. So, would it be better to try and re-write the query to get all the relevant data in one giant query, or leave it as is? Or would there be a better way to handle this? Just seems kind of inefficient to run all those extra queries.
Any input would be appreciated. -- James Husum The Quixote Project - one guy's quest to make the world a better place - http://www.thequixoteproject.org/ Brainsludge - all the shtuff running around my brain - http://www.brainsludge.com/ Know any writers? I need their input! - http://www.smotu.org/ Currently reading: The Sapphire Rose by David Eddings --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the "Houston ColdFusion Users' Group" discussion list. To unsubscribe, send email to [EMAIL PROTECTED] For more options, visit http://groups.google.com/group/houcfug?hl=en -~----------~----~----~----~------~----~------~--~---
