James-- You can certainly make it a faster page and reduce DB calls if you rewrite the query. However, it's going to be tedious work that results in no visible difference to the user. Unless the page is running slowly or is becoming a bear to maintain as-is, I would make a note about it and devote my time to other tasks that are more visible to stakeholders (by which I mean "paycheck-writers").
-CPC On Oct 7, 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 --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
