Hi Folks,
We have multiple developers running multiple applications on our server.
We've been having problems, and yes, we've read all the allaire docs on
performance tuning. One of our problems is that we have a number of
large-ish access applications. (Ugh, I know.)
I may have found a clue today. I found one query that seemed to be crashing
the server consistently. The only thing different about this query is that
it concantenated two columns into one variable - ie -
Select (can_fname & ' ' & can_lname) AS canname
When I took this out, and banged on the app again, I had no problems.
Has anyone else ever seen this happen or is this merely a fluke?
<cf_graspingatstraws todaysstraw="concantenation">
-d
************************************************************
Deanna Schneider
Interactive Media Developer
UWEX Cooperative Extension Electronic Publishing Group
103 Extension Bldg
432 N. Lake Street
Madison, WI 53706
(608) 265-7923
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
