There's a good chance that your client variable storage is the problem. How
large is the database? Is there any way you can do without it?

I personally have some reservations about using client database storage. The
idea is great, but the implementation is poor. On my SQL 2k server, we can
watch as client variables prepare and unprepare stored procs to set and
update variables. This is a mean thing to do to a database.

If at all possible, change your client storage to cookies, or do a
roll-your-own client storage mechanism. I've been thinking about this for a
while and have come up with a number of ideas. Let me know if you want any
of them.

-nathan strutz

  -----Original Message-----
  From: Claudia Hoag [mailto:[EMAIL PROTECTED]
  Sent: Tuesday, February 24, 2004 11:34 AM
  To: CF-Talk
  Subject: Execution time for cfapplication tag

  Hello,

  My Application.cfm is taking 390ms to run, which is actually the
cfapplication tag alone taking 350ms. Shouldn't it run faster than that? Is
that because I'm using a database for clientstorage? (it's MS SQL 2k)
  Here's the tag:
  <cfapplication
  name="myapp"
  loginStorage="cookie"
  clientmanagement="Yes"
  clientstorage="myappClientStorage"
  setdomaincookies="Yes"
  setclientcookies="Yes">

  TIA,
  Claudia
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to