Farcry 6.2 Request Time Out Issue

--001a11402b18d0ac8105229785f4
Content-Type: text/plain; charset=UTF-8

Hi folks,

I got a strange request time out issue for my farcry 6.2 site, when it
switched to connect to the production database server.
It was exactly the same code running on the same server but connecting to
an internal SIT database server without any issue.

After the data source changed, now any page request will time out even if
it only contains one line of cfoutput code.
It looked like a database issue to me initially so I created another test
site (Non-farcry) with only one page request to the database I'm having
problem with, and I can get the response back without issue.

From the debugger information I can see
C:/wwwroot/mysite/farcry/core/tags/farcry/_farcryApplicationInit.cfm took
long time to execute:

Total Time Avg Time Count Template

*192387ms 192387ms 1
C:/wwwroot/mysite/farcry/core/tags/farcry/_farcryApplicationInit.cfm
141380ms 1285ms 110
C:/wwwroot/mysite/farcry/core/packages/fourq/_fourq/getData.cfm 42486ms
42486ms 1 CFC[C:/wwwroot/mysite/farcry/core/packages/security/security.cfc
| init() ]*

Also any query to the *farPermission* table took more than 5 seconds to
execute.

The site is running farcry 6.2 on ColdFusion 11 update 6, Windows 2012 R2
standard server 64 bit. IIS 8.5.

Could anyone share some thoughts on this? I got no clue at the moment [image:
:frowning:]

Thanks,
Xiaofeng

-- 
Best regards,

Xiaofeng,^_^

-- 
You received this message cos you are subscribed to "farcry-dev" Google group.
To post, email: farcry-dev-/[email protected]
To unsubscribe, email: farcry-dev+unsubscribe-/[email protected]
For more options: http://groups.google.com/group/farcry-dev
--------------------------------
Follow us on Twitter: http://twitter.com/farcry
--- 
You received this message because you are subscribed to the Google Groups "farcry-dev" group.
To unsubscribe from this group and stop receiving emails from it, send an email to farcry-dev+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/[email protected]
For more options, visit https://groups.google.com/d/optout.

--001a11402b18d0ac8105229785f4
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><p style=3D"margin-top:0px;font-family:Helvetica,Arial,san=
s-serif;font-size:14px;line-height:19px">Hi folks,</p><p style=3D"font-fami=
ly:Helvetica,Arial,sans-serif;font-size:14px;line-height:19px">I got=C2=A0a=
 strange request time out issue for my farcry 6.2 site, when it switched to=
 connect to the production database server.<br>It was exactly the same code=
 running on the same server but connecting to an internal SIT database serv=
er without any issue.</p><p style=3D"font-family:Helvetica,Arial,sans-serif=
;font-size:14px;line-height:19px">After the data source changed, now any pa=
ge request will time out even if it only contains one line of cfoutput code=
.<br>It looked like a database issue to me initially so I created another t=
est site (Non-farcry) with only one page request to the database I&#39;m ha=
ving problem with, and I can get the response back without issue.</p><p sty=
le=3D"font-family:Helvetica,Arial,sans-serif;font-size:14px;line-height:19p=
x">From the debugger information I can see C:/wwwroot/mysite/farcry/core/ta=
gs/farcry/_farcryApplicationInit.cfm took long time to execute:<br><br></p>=
<p style=3D"font-family:Helvetica,Arial,sans-serif;font-size:14px;line-heig=
ht:19px">Total Time Avg Time Count Template</p><p style=3D"font-family:Helv=
etica,Arial,sans-serif;font-size:14px;line-height:19px"><span style=3D"font=
-size:small"><font color=3D"#ff0000"><b>192387ms 192387ms 1 C:/wwwroot/mysi=
te/farcry/core/tags/farcry/_farcryApplicationInit.cfm 141380ms 1285ms 110 C=
:/wwwroot/mysite/farcry/core/packages/fourq/_fourq/getData.cfm 42486ms 4248=
6ms 1 CFC[C:/wwwroot/mysite/farcry/core/packages/security/security.cfc | in=
it() ]</b></font></span></p><p style=3D"margin-top:0px;font-family:Helvetic=
a,Arial,sans-serif;font-size:14px;line-height:19px">Also any query to the <=
b>farPermission</b> table took more than 5 seconds to execute.</p><p style=
=3D"font-family:Helvetica,Arial,sans-serif;font-size:14px;line-height:19px"=
>The site is running farcry 6.2 on ColdFusion 11 update 6, Windows 2012 R2 =
standard server 64 bit. IIS 8.5.</p><p style=3D"font-family:Helvetica,Arial=
,sans-serif;font-size:14px;line-height:19px">Could anyone share some though=
ts on this? I got no clue at the moment=C2=A0<img src=3D"http://discourse.f=
arcrycore.org/images/emoji/emoji_one/frowning.png?v=3D0" title=3D":frowning=
:" class=3D"" alt=3D":frowning:" style=3D"border: 0px; vertical-align: midd=
le; width: 20px; height: 20px; max-width: 690px; max-height: 500px;"></p><p=
 style=3D"font-family:Helvetica,Arial,sans-serif;font-size:14px;line-height=
:19px">Thanks,<br>Xiaofeng</p><div><br></div>-- <br><div class=3D"gmail_sig=
nature">Best regards,<br><br>Xiaofeng,^_^</div>
</div>

<p></p>

-- <br />
You received this message cos you are subscribed to &quot;farcry-dev&quot; =
Google group.<br />
To post, email: farcry-dev-/[email protected]<br />
To unsubscribe, email: farcry-dev+unsubscribe-/[email protected]<br />
For more options: <a href=3D"http://groups.google.com/group/farcry-dev">htt=
p://groups.google.com/group/farcry-dev</a><br />
--------------------------------<br />
Follow us on Twitter: <a href=3D"http://twitter.com/farcry">http://twitter.=
com/farcry</a><br />
--- <br />
You received this message because you are subscribed to the Google Groups &=
quot;farcry-dev&quot; group.<br />
To unsubscribe from this group and stop receiving emails from it, send an e=
mail to <a href=3D"mailto:farcry-dev+unsubscribe-/[email protected]">farcry-d=
ev+unsubscribe-/[email protected]</a>.<br />
For more options, visit <a href=3D"https://groups.google.com/d/optout">http=
s://groups.google.com/d/optout</a>.<br />

--001a11402b18d0ac8105229785f4--