> Do you think that changing the index on this table to clustered from
> nonclustered would provide us with performance improvements?
Well, queries that use a clustered index generally run significantly
faster than queries that use a nonclustered index. If you only put one
index on a table, it's
Hi Dave (or anyone),
Another quick follow up (about clustered vs nonclustered indexes) indexing
the CDATA table.
You mentioned creating an index on CDATA like the following (ie a clustered
index).CREATE UNIQUE CLUSTERED INDEX idxCDATA
ON cdata (cfid, app)
It turns out that in some cases we alrea
You may also see a slight performance boost if you change the data fields
from text to varchar(max) if you are on sql 2005+, plus storage size is
better. Pretty sure this was ok to do with CF8 plus.
Also be mindful of how much data you put into the client scope. Less the
better, since every reque
Indexes can become fragmented over time, however. If you add the
indexes and note degradation of performance after a while, then you may
need to look at rebuilding indexes and statistics. If you are using SQL
Server, there are tools built-in to set up automated maintenance plans
which can in
> A quick follow up. We are only keeping data in these tables for 1-3 days,
> and it's obviously changing a lot as the site is used. So, does that mean
> that once the indexes are created, they should be re-indexed / rebuilt
> frequently (because of the frequent changes in the data)?
No, the da
data)?
Nick
Return-Path:
Received: from mail.houseoffusion.com [64.118.74.225] by
mail67.safesecureweb.com with SMTP;
Tue, 5 Mar 2013 16:42:07 -0500
To: cf-talk
Message-ID:
Subject: Re: Creating indexes on cdata and cglobal tables?
References: <
> We use client variables in our client databases and I've seen some
> information that you can get better performance by creating indexes on
> those tables. For instance this page
> (http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=sharedVar
> s_08.html) says the following:"To i
Hi Folks,
We use client variables in our client databases and I've seen some
information that you can get better performance by creating indexes on
those tables. For instance this page
(http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=sharedVar
s_08.html) says the following:"T
8 matches
Mail list logo