RE: CDATA / CGLOBAL Purging

2010-02-24 Thread Paul Alkema
Watts [mailto:dwa...@figleaf.com] Sent: Wednesday, February 24, 2010 12:58 PM To: cf-talk Subject: Re: CDATA / CGLOBAL Purging > I recently installed Fusion Reactor on my server. While viewing queries that > every page hit I noticed a query that I didn't recognize that was taking up >

Re: CDATA / CGLOBAL Purging

2010-02-24 Thread Dave Watts
> I recently installed Fusion Reactor on my server. While viewing queries that > every page hit I noticed a query that I didn't recognize that was taking up > a significant amount of load time. These queries were to the tables CDATA > and CGLOBAL. > > Upon research I found that this was caused by

RE: CDATA / CGLOBAL Purging

2010-02-24 Thread Che Vilnonis
DELETE FROM CDATA WHERE CFID = '#getOldCVRs.CFID#' -Original Message- From: Paul Alkema [mailto:paulalkemadesi...@gmail.com] Sent: Wednesday, February 24, 20

CDATA / CGLOBAL Purging

2010-02-24 Thread Paul Alkema
Hi all, I recently installed Fusion Reactor on my server. While viewing queries that every page hit I noticed a query that I didn't recognize that was taking up a significant amount of load time. These queries were to the tables CDATA and CGLOBAL. Upon research I found that this was caused by our

Re: Flushing CDATA/CGLOBAL db tables (nevermind!)

2007-12-12 Thread Scott Weikert
The data in my CDATA/CGLOBAL tables finally ended up getting flushed - just had to be patient. :) Nevermind! ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how

Flushing CDATA/CGLOBAL db tables?

2007-12-12 Thread Scott Weikert
Our server guy is getting ready to do some major work on our DB server (MS SQL). I'm trying to get the CDATA/CGLOBAL tables trimmed down so that the DB will copy off that box over to a temp DB box easier. I've set the "purge unvisited" setting for the client variables down t

RE: CDATA & CGLOBAL

2002-07-04 Thread Stacy Young
to:[EMAIL PROTECTED]] Sent: Thursday, July 04, 2002 6:20 AM To: CF-Talk Subject: CDATA & CGLOBAL Anyone know if you can change the table names that CFMX looks for when using client variables in a database? We normally use table prefixes like: applicationName.cdata applicationName.cglobal

RE: CDATA & CGLOBAL

2002-07-04 Thread Costas Piliotis
ECTED]] Sent: Thursday, July 04, 2002 6:20 AM To: CF-Talk Subject: CDATA & CGLOBAL Anyone know if you can change the table names that CFMX looks for when using client variables in a database? We normally use table prefixes like: applicationName.cdata applicationName.cglobal but CFMX do

CDATA & CGLOBAL

2002-07-04 Thread Stacy Young
Anyone know if you can change the table names that CFMX looks for when using client variables in a database? We normally use table prefixes like: applicationName.cdata applicationName.cglobal but CFMX doesn't see the tables...not too difficult to workaround but was wondering anyhow...