Ok... Get this! If you run a page with debugging info in it, it does 10 database hits per second. It must be hits to the internal database. This however, does skew results when trying to debug database resource issues.
Paul > -----Original Message----- > From: Paul Johnston [mailto:[EMAIL PROTECTED] > Sent: 12 December 2003 15:14 > To: [EMAIL PROTECTED] > Subject: RE: [ cf-dev ] Query of queries issue > > > 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] > -- ** 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]
