It is inefficient but is the page slow or is anyone complaining about its speed? Don't fix it unless it is broke. :)
On Tue, Oct 7, 2008 at 6:00 AM, James Husum <[EMAIL PROTECTED]> wrote: > 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 > > > > -- Aaron Rouse http://www.happyhacker.com/ --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
