It's a Mach II app where a chunk of output data is stored in a query that is in turn stored in a session var. The queries come from the Mach II xml document so changing them there is out. The big problem with your suggestion (which is the logical one) is that there is no QueryDeleteRow() function in CF. In order to delete a row in a query, you have to build a new query and replace the old one with the new. If I'm going to do that, I may as well just build the new query with the rows I want. As for replacing the IN with multiple OR statements, I'd think that would be a lot more inefficient based on logic but someone better in SQL can tell me that I'm wrong.
That being said, I wrote the QueryofQuery() function and will be testing it on the box in a few moments. My current tests show no speed difference which is good. If I see a drop in CPU usage then I'll be VERY happy. The goal of this little exercise is not saving time but lowering the CPU usage. > Does the app need to the QoQ in first place? Could you maybe replace it > by manipulating it with struct syntax? Or replace it by deleting the > records you don't need (instead of selecting the ones you need). Or how > about replacing the in statement with repeated UUID = "X" OR statements. > > /H. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238608 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
