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]
