Removing the cfapplication tag seems to make little if no difference. Does the performance monitoring include query of queries?
Paul > -----Original Message----- > From: Stephen Pope [mailto:[EMAIL PROTECTED] > Sent: 12 December 2003 15:05 > To: [EMAIL PROTECTED] > Subject: RE: [ cf-dev ] Query of queries issue > > > Yeah, might be the writing of client vars / client store to > the DB (last visit etc information) > > Stephen > > -----Original Message----- > From: Adrian Lynch [mailto:[EMAIL PROTECTED] > Sent: 12 December 2003 15:05 > To: '[EMAIL PROTECTED]' > Subject: RE: [ cf-dev ] Query of queries issue > > CLIENT/SESSION variables maybe? Althought I think CF doesn't > write to the DB each time for this. Although there may be a > setting to change this either way. > > Ade > > -----Original Message----- > From: Paul Johnston [mailto:[EMAIL PROTECTED] > Sent: 12 December 2003 15:00 > To: [EMAIL PROTECTED] > Subject: [ cf-dev ] Query of queries issue > > > I have been doing some testing of an application and checking > the database load that it is putting on my server. I have > counted in the debugging 9 queries that are called by every > page (and are to be optimised). However, I am receiving a > load of 40+ DB hits for each page request. I do have a bunch > of Query of queries, but it's not another 30 on the page. > > Anyone know why my db hit is so high? I am doing > cfapplication, so that will account for part of it, but that > should only be 1 or 2 hits shouldn't it? > > Paul > -------------------------- > Paul Johnston > PJ Net Solutions Ltd > E: [EMAIL PROTECTED] > M: +44 7866 573013 > > > > -- > ** 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] > > -- > ** 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] > > > -- > ** 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] > -- ** 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]
