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
>
> 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
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#'
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:
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
5 matches
Mail list logo