When you say a dozen queries per user... Is that per page hit? Or per session?
If none of the queries you are querying is over 20 rows, are you sure this IS the bottleneck? If you have the queries return just a single row regardless of UUID, do you see a dramatic performance increase? -ben ....................... Ben Nadel www.bennadel.com Sanders: Lightspeed too slow? Helmet: Yes we'll have to go right to ludacris speed. -----Original Message----- From: Michael Dinowitz [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 25, 2006 11:17 AM To: CF-Talk Subject: replacement for QoQ 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:238607 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
