You don't say what DB it is, but I'd start by
running a request profiler against it. See if
the slowdown is on the DB side or the CF side.
Yeah, that was all covered in the original post I think. It's MS-SQL and
the same query run in query analyzer or from another one of our web servers
You don't say what DB it is, but I'd start by running a request
profiler against it. See if the slowdown is on the DB side or the CF
side. I'd also take a look at your logging. If the log files on
production are filling up the disc, then additional logging to rows
with text fields may be swapping
Ok, here's a really odd one. Today one of our ColdFusion servers started
getting really slow responses from queries that include a particular table
from the database. Any query that doesn't query that table runs fine.
First thought is that something with that table is screwy. However, running
On Fri, May 22, 2009 at 9:42 PM, Justin Scott wrote:
First thought is that something with that table is screwy. However, running
the same query against the same database from a different ColdFusion server
(same version, jvm, configuration, etc.) returns the result normally.
Exactly the same
Exactly the same configuration? With the same settings
for Unicode for query parameters and CLOB buffer?
Yes, the data source configuration has all of the same settings. The really
strange part is that everything has been working fine for weeks since the
last code updates that we deployed,
I know this doesn't solve ur issue but ...
I have had a few really bad problems similar to this with text fields in the
past. I almost rather store a file on my own than use a text data type.
Similar to storing an image link.
--
Ryan
On Fri, May 22, 2009 at 3:00 PM, Justin Scott
6 matches
Mail list logo