Sorry, the queries are stored in the user request object, not the session. This means per page hit (which really sucks). I wish I knew more about the internal workings and reasoning under Mach II so I could just make these session, application or just straight queries without being in memory. As for it being the bottleneck, these queries were running over 10000ms per query before I made some mods (changes an evaluate to a struct evaluate and a few other minor fixes) and now they're down to about 250ms per query. For a QoQ this is nowhere near right and all my investigations so far point to this as the source. But I could be wrong which means more billable hours. :)
> 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:238612 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
