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.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238596 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
