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
YUP, write a query against both of these tables to delete all entries that are older than a certain data range. I've done something like this in the past... btw, this is old code :) SELECT CFID FROMCGLOBAL WHERE LVISIT <= '#XAtMidnight#'

RE: CDATA & CGLOBAL

2002-07-04 Thread Stacy Young
No we don't use periods in table names...They're synonyms (at the db level). Anyhow no biggie...the DBA will just create an alias... Thanks! -Original Message- From: Costas Piliotis [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 04, 2002 1:06 PM To: CF-Talk Subject:

RE: CDATA & CGLOBAL

2002-07-04 Thread Costas Piliotis
You guys put periods in table names? YUCK... That means you need a square bracket around every table name... Not a very common practice... What you COULD TRY is to create two views called CDATA and CGLOBAL as such: CREATE VIEW CDATA AS SELECT * FROM [applicationName.cdata] GO CREATE VIEW C