Check in your administrator under client variables section and see if
your client vars are stored in a DB or in the registry or cookie.

Stephen

-----Original Message-----
From: Paul Fennell [mailto:[EMAIL PROTECTED] 
Sent: 12 December 2003 15:21
To: [EMAIL PROTECTED]
Subject: RE: [ cf-dev ] Query of queries issue

Paul 
IS your Clients-Session DB Separate than your application DB ?


> 
> -----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]

---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.551 / Virus Database: 343 - Release Date: 11/12/2003
 

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.551 / Virus Database: 343 - Release Date: 11/12/2003
 


-- 
** 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]

Reply via email to