Client Variables and Purging...

[Matthew R. Learn]

I would love for some thoughts on this.  I work for a small software
development company, we have a web application deployed at several clients
using Coldfusion.  One of the things that we do is in the Client Variables
we use a database storage.  Recently I have found that clients were having
system slow down issues every hour, and I think that it is happening because
of the Purge Interval, which was left at the default 1 hour.  

Questions:
1)  I was reading some place about having the Database do the purge instead
of CF, if I went that route, how can I disable the CF Purge?
2) Most of the servers are set to restart every night (the user base is such
that the system is usually only during business hours), does the purge
interval go from the last time that Coldfusion restarted?  So if I set a
purge interval of 23 hours, then the purge would happen 1 hour before the
restart, right?  
3)  The datasource that we use to store the Client Variables is used by
other queries in the system.  Is this part of the problem?  Should the data
source used for Client Variables only be used for client variable
information?  Would creating a dedicated datasource for Client Variables
prevent the bottle neck?  

I have done some Google searching, and there really is not a lot of
information about the Client Variables and the purge interval.  I am hoping
that someone out there has some real life experience with this issue and
have a good suggestion.  Thank you.

-Matthew R. Learn
        Modotech Inc.
        matthew@...
        410-972-2165





~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: http://www.houseoffusion.com/groups/cf-server/message.cfm/messageid:6771
Subscription: http://www.houseoffusion.com/groups/cf-server/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.10

On Thursday 26 Mar 2009, Matthew Learn wrote:
> we use a database storage.  Recently I have found that clients were having
> system slow down issues every hour, and I think that it is happening
> because of the Purge Interval, which was left at the default 1 hour.

Back your thoughts up. What does the database say the top N queries are that
time ?

--
Tom Chiverton
Helping to augmentatively visualize bleeding-edge users as part of the IT team
of the year, '09 and '08

****************************************************

This email is sent for and on behalf of Halliwells LLP.

Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB.  A list of members is available for inspection at the registered office together with a list of those non members who are referred to as partners.  We use the word “partner” to refer to a member of the LLP, or an employee or consultant with equivalent standing and qualifications. Regulated by the Solicitors Regulation Authority.

CONFIDENTIALITY

This email is intended only for the use of the addressee named above and may be confidential or legally privileged.  If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents.  If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500.

For more information about Halliwells LLP visit www.halliwells.co

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: http://www.houseoffusion.com/groups/cf-server/message.cfm/messageid:6772
Subscription: http://www.houseoffusion.com/groups/cf-server/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.10

[Mike Chytracek]

What database application are you using to store the client vars?  If you
are using MSACCESS, this is likely the problem.  We encountered similar
issues when using Access..

Mike


-----Original Message-----
From: Matthew Learn [mailto:matthew@...]
Sent: Thursday, March 26, 2009 11:16 AM
To: cf-server
Subject: Client Variables and Purging...


I would love for some thoughts on this.  I work for a small software
development company, we have a web application deployed at several clients
using Coldfusion.  One of the things that we do is in the Client Variables
we use a database storage.  Recently I have found that clients were having
system slow down issues every hour, and I think that it is happening because
of the Purge Interval, which was left at the default 1 hour.  

Questions:
1)  I was reading some place about having the Database do the purge instead
of CF, if I went that route, how can I disable the CF Purge?
2) Most of the servers are set to restart every night (the user base is such
that the system is usually only during business hours), does the purge
interval go from the last time that Coldfusion restarted?  So if I set a
purge interval of 23 hours, then the purge would happen 1 hour before the
restart, right?  
3)  The datasource that we use to store the Client Variables is used by
other queries in the system.  Is this part of the problem?  Should the data
source used for Client Variables only be used for client variable
information?  Would creating a dedicated datasource for Client Variables
prevent the bottle neck?  

I have done some Google searching, and there really is not a lot of
information about the Client Variables and the purge interval.  I am hoping
that someone out there has some real life experience with this issue and
have a good suggestion.  Thank you.

-Matthew R. Learn
        Modotech Inc.
        matthew@...
        410-972-2165







~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: http://www.houseoffusion.com/groups/cf-server/message.cfm/messageid:6773
Subscription: http://www.houseoffusion.com/groups/cf-server/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.10

[Matthew R. Learn]

Now, we are using MS SQL Servers, both 2000 and 2005 on various clients.  

-Matthew R. Learn


-----Original Message-----
From: Mike Chytracek [mailto:mikechy@...]
Sent: Thursday, March 26, 2009 12:29 PM
To: cf-server
Subject: RE: Client Variables and Purging...


What database application are you using to store the client vars?  If you
are using MSACCESS, this is likely the problem.  We encountered similar
issues when using Access..

Mike


-----Original Message-----
From: Matthew Learn [mailto:matthew@...]
Sent: Thursday, March 26, 2009 11:16 AM
To: cf-server
Subject: Client Variables and Purging...


I would love for some thoughts on this.  I work for a small software
development company, we have a web application deployed at several clients
using Coldfusion.  One of the things that we do is in the Client Variables
we use a database storage.  Recently I have found that clients were having
system slow down issues every hour, and I think that it is happening because
of the Purge Interval, which was left at the default 1 hour.  

Questions:
1)  I was reading some place about having the Database do the purge instead
of CF, if I went that route, how can I disable the CF Purge?
2) Most of the servers are set to restart every night (the user base is such
that the system is usually only during business hours), does the purge
interval go from the last time that Coldfusion restarted?  So if I set a
purge interval of 23 hours, then the purge would happen 1 hour before the
restart, right?  
3)  The datasource that we use to store the Client Variables is used by
other queries in the system.  Is this part of the problem?  Should the data
source used for Client Variables only be used for client variable
information?  Would creating a dedicated datasource for Client Variables
prevent the bottle neck?  

I have done some Google searching, and there really is not a lot of
information about the Client Variables and the purge interval.  I am hoping
that someone out there has some real life experience with this issue and
have a good suggestion.  Thank you.

-Matthew R. Learn
        Modotech Inc.
        matthew@...
        410-972-2165









~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: http://www.houseoffusion.com/groups/cf-server/message.cfm/messageid:6774
Subscription: http://www.houseoffusion.com/groups/cf-server/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.10

[paul morgan-witts]

We are seeing the same problem.  The hourly slowdowns are driving us crazy.

We get around 400K unique visitors a month, and client-based cookies were not working well for us (PCI problems amongst other things).

Looking into the cookies database (MSSQL), we saw 3m cookies stored. Well, maybe with the visitors+robots*3 that makes sense (but worries me about the scalability of it!).

So we changed the cookie age/purge from 90 days to 45 days, and voila - 6m cookies in 10 hrs.  Yes, it doubled the size of the database! Beats the heck out of me.

Any CF gurus have any ideas/best practices?


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: http://www.houseoffusion.com/groups/cf-server/message.cfm/messageid:6793
Subscription: http://www.houseoffusion.com/groups/cf-server/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.10

[paul morgan-witts]

We are seeing the same problem.  The hourly slowdowns are driving us crazy.

We get around 400K unique visitors a month, and client-based cookies were not working well for us (PCI problems amongst other things).

Looking into the cookies database (MSSQL), we saw 3m cookies stored. Well, maybe with the visitors+robots*3 that makes sense (but worries me about the scalability of it!).

So we changed the cookie age/purge from 90 days to 45 days, and voila - 6m cookies in 10 hrs.  Yes, it doubled the size of the database! Beats the heck out of me.

Any CF gurus have any ideas/best practices?

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: http://www.houseoffusion.com/groups/cf-server/message.cfm/messageid:6794
Subscription: http://www.houseoffusion.com/groups/cf-server/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.10

[paul morgan-witts]

>I would love for some thoughts on this.  I work for a small software
>development company, we have a web application deployed at several clients
>using Coldfusion.  One of the things that we do is in the Client Variables
>we use a database storage.  Recently I have found that clients were having
>system slow down issues every hour, and I think that it is happening because
>of the Purge Interval, which was left at the default 1 hour.  

We are seeing the same problem.  The hourly slowdowns are driving us crazy.

We get around 400K unique visitors a month, and client-based cookies were not working well for us (PCI problems amongst other things).

Looking into the cookies database (MSSQL), we saw 3m cookies stored. Well, maybe with the visitors+robots*3 that makes sense (but worries me about the scalability of it!).

So we changed the cookie age/purge from 90 days to 45 days, and voila - 6m cookies in 10 hrs.  Yes, it doubled the size of the database! Beats the heck out of me.

Any CF gurus have any ideas/best practices?

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: http://www.houseoffusion.com/groups/cf-server/message.cfm/messageid:6795
Subscription: http://www.houseoffusion.com/groups/cf-server/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.10