Client/sessions been stored in the same db ? If you can have a 2nd db - have just a client/store db - separate than your application Db -
-----Original Message----- From: Paul Johnston [mailto:[EMAIL PROTECTED] Sent: 12 December 2003 15:26 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] Query of queries issue > 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. Session/client vars was the first place I looked. And all my client vars are stored in the db, but since I'm not using any client vars, just sessions, so it wasn't actually important. The thing is, that my results are getting skewed. If I look at the code, it should only do 9 SQL Server queries. According to CF, just using debugging does 10 db hits/sec. Which isn't helpful... Hmmm... 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] --- 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]
