Jordan Michaels wrote:
> Charles Cruise wrote:
>
>
>> Hi all, i have a weird problem with a page that has an execution time of
>> 46031 milliseconds. There is only one file that is causing the
>> problem. If i comment out the <cfinclude> tag that includes the file,
>> the page loads fine naturally. However, if I erase the contents of the
>> file so that it is blank, it still takes a long time to process that
>> file. Should it do that? If not, I'm at a loss as to where to go from
>> here on solving the high execution time.
>>
>> Some information about the file, it contains one <cfquery> that
>> debugging reports takes 0 ms for the time, and one <cfif> statement
>> that checks to see if the recordcount of the query is greater than 0.
>> If it is, it displays some html. If not, it does nothing.
>>
>> Thanks in advance for any and all suggestions on this mysterious problem.
>> Charles Cruise
>> Vice President / Network Operations
>> Web Site Management, Inc.
>>
>>
>>
>>
> This sounds more like a problem with the processing engine then with
> your code. What happens to your memory usage when you run that page? Is
> it spiking?
>
> Have you restarted your instance of CF Server? Did it help? Is there
> anything that could give a clue as to what's happening in the logs? Both
> CFServer and apache logs? (IE: Segmentation faults of any kind?)
>
> HTH!
>
>
Memory usage just seems to slowly go up while the page loading. CPU
usage just seems to stay steady. I restarted my instance of CF 5 Server
and still does the same thing.
In the application log for CF 5 server, I'm seeing
ODBC Error Code = 01000 (General warning)<P> [Microsoft][ODBC SQL
Server Driver][DBNETLIB]ConnectionRead (recv()).<P><P> SQL =
which i haven't seen before in the logs.
In the IIS server logs, there doesn't seem to be any errors standing out
when I run the page.
Thanks again,
Charles Cruise
Vice President / Network Operations
Web Site Management, Inc.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236256
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
