> Do you know a better one? ;-) Yes. (me speaking to developer who wrote that):
"I warned you already to always scope your vars, ye idgit!" ***thwack!*** *thud* I reworked some old code and jiggered the db structure for someone within the last week that took their processing time from like 40 seconds to about 1 second. It was a recursive tree view of a bunch of categories, but it turned out that you only had to go one level down to do what was needed. Then I found the thing that was recursing down umpteen levels was just pulling a recordcount and reporting the grand total count back to the top-level template. This was maybe their most-visited page on the site. Naturally the queries (all 399 of them, I kid you not) were SELECT * and the field in the WHERE clause was unindexed. Oh and the results were not in use anywhere. Someone had decided they didn't want to use it I guess, and pulled the <cfoutput>#spank_me#</cfoutput> but left in the tag calls. -- --mattRobertson-- Janitor, MSB Web Systems mysecretbase.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212667 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
