| I'm debugging a Mach II app and there is a massive bottleneck in a | single portion of it where a query that is stored in memory is queried
| against using an IN statement. The IN statement is using over 20 UUIDs | as the elements to find which is quite insane, especially as none of | the queries are over 20 rows. I was wondering if anyone has written | some code to replace a query of queries? If not, I'll write one. | When I say massive bottleneck, I mean it spikes the CPU to the top as | it's going through a dozen queries per user. nasty. 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:238602 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
