Ok... I have resolved the issue and found that only 9 queries were getting run in total.
Moral of the story: Don't trust the statistics that the CF Server gives you with regards to db hits/sec!!! That's because, according to those stats, when I cache all the queries, and store everything I can in the application scope, I still have 28 db hits/sec for 1 request! That doesn't seem right to me, esp as when I check the SQL Server using Profiler, nothing has gone in or out. Ok... MM time to sort this one out or explain it! Paul -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
