Quick answer to your question... I'm lucky enough that there's little to no traffic at 3am, so I've never had an issue purging the databases completely at 3am. Originally I had written a little script to only purge the ones where the lastvisit was x days ago but it that solution isn't nearly as fast as just saying "TRUNCATE TABLE CDATA" and "TRUNCATE TABLE CGLOBAL". Just a matter of personal preference. Depending on the hours/nature of your website your mileage may vary. If your site is a critical ecommerce application and has a constant flow 24/7 then you may wish to seriously consider "rolling your own". Then you have complete control over how things work. I for one haven't been all that impressed by the structure of the CDATA/CGLOBAL tables myself. It all depends on what you're doing I suppose.
-Novak ----- Original Message ----- From: "WebMaster" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, January 16, 2003 7:19 AM Subject: Re: CDATA dup insert error Again > Yeah, I thought of that, unfortunately, I can't rely on cookies. Life would > be so much easier if I could just use cookies. I know this will start a > thread, but with IE6, MS has made it so easy for users to turn off cookies, > we have found that we loose customers on our e-commerce sites, so we have to > code the CFTOKEN into all our form fields. You will notice that most major > sites such as Amazon work without cookies. I think this is a trend and we > will see more of this in the future. So if you are dealing with the general > public, not an internal site, I think more and more people will be turning > off cookies because of the "privacy" hype. Just my 2 cents, I may be wrong, > but our client demanded that the e-commerce sites work without cookies. > We use CLIENT vars on all the pages because we have to keep track of the > session. We can't use session vars because they don't scale.. (They don't > work behind a load balancer). So, my dilemma.... I might have to change > all the code to store the client vars myself in my own db as you suggested > if MM doesn't fix the problem.. You say you purge your ccdata and cglobal > every night. What happens if you have a user tied to a client var and you > delete it while they are in the site? I am not sure this will work for me. > I purge them after two days. I had it weekly, but got too many error,s > setting to 2 days helped a little, but as traffic builds, it's getting > worse. > I JUST CAN'T BELIEVE MM WILL NOT FIX THIS. Yes MM, I am shouting...Do you > hear us???? It's been on the bug list as a sev 2 since 4.5. PLEASE FIX > THIS!!!!!!!! Do they even listen to this list??? > Sorry for shouting guys... It has been a long night... > Best Regards, > Joe "underbar" Hansen > > ----- Original Message ----- > From: <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Thursday, January 16, 2003 9:53 AM > Subject: Re: CDATA dup insert error Again > > > > I know this doesn't solve your problem... but... you can always "roll your > > own". Heck, all it is (more or less) is setting a cookie on the client's > > browser with a UUID then writing/updating a database table. Toss the > "read" > > routine in your application.cfm page and you'll end up reading the > client's > > info every time. > > > > Or, even better... if your application doesn't need that data every > time... > > you can make a call to the routine only when you do need it. That's even > > more efficient as it eliminates unneeded calls to the database. > > > > I personally have never relied on client variables for much more than > > session stuff. I purge my CDATA and CGLOBAL tables every night and never > > have any problems. > > > > -Novak > > > > ----- Original Message ----- > > From: "Webmaster" <[EMAIL PROTECTED]> > > To: "CF-Talk" <[EMAIL PROTECTED]> > > Sent: Thursday, January 16, 2003 4:46 AM > > Subject: Re: CDATA dup insert error Again > > > > > > > I just read a long thread on this and MM has it as a bug, but it seems > > they > > > are not going to fix it. What a rip... > > > > > > > > > ----- Original Message ----- > > > From: "Webmaster" <[EMAIL PROTECTED]> > > > To: "CF-Talk" <[EMAIL PROTECTED]> > > > Sent: Wednesday, January 15, 2003 11:22 PM > > > Subject: CDATA dup insert error Again > > > > > > > > > > Hi, > > > > I am still getting this error. The last time I asked the list we > went > > > > around in circles about locking and purging the client var data store. > > > > Well, the purge is working fine. I have it set to one week and there > > are > > > > only a weeks worth of entries in the db. I don't understand how this > > can > > > > happen. I am using the Uuid version of the cftoiken so it is supposed > > to > > > > guarantee unique values (TechNote 22427) > > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
