Re: Farcry 6.2 Request Time Out Issue

------=_Part_5134_1926908327.1445437675513
Content-Type: multipart/alternative; 
	boundary="----=_Part_5135_149569704.1445437675514"

------=_Part_5135_149569704.1445437675514
Content-Type: text/plain; charset=UTF-8

You're not going to get much response here, take your question to 
http://discourse.farcrycore.org

that is the new discussion forum

That said, does your database have the required indexes, etc?  Also, are 
you connecting to a separate server? Is there a network bottleneck between 
the web and DB servers?

Don't respond here, start a new post in Discourse and we can discuss there 
and others can chime in as well.

Sean


On Wednesday, October 21, 2015 at 2:31:08 AM UTC-4, Xiaofeng Liu wrote:
>
> 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.

------=_Part_5135_149569704.1445437675514
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">You&#39;re not going to get much response here, take your =
question to http://discourse.farcrycore.org<div><br></div><div>that is the =
new discussion forum</div><div><br></div><div>That said, does your database=
 have the required indexes, etc? =C2=A0Also, are you connecting to a separa=
te server? Is there a network bottleneck between the web and DB servers?</d=
iv><div><br></div><div>Don&#39;t respond here, start a new post in Discours=
e and we can discuss there and others can chime in as well.</div><div><br><=
/div><div>Sean</div><div><br><br>On Wednesday, October 21, 2015 at 2:31:08 =
AM UTC-4, Xiaofeng Liu wrote:<blockquote class=3D"gmail_quote" style=3D"mar=
gin: 0;margin-left: 0.8ex;border-left: 1px #ccc solid;padding-left: 1ex;"><=
div dir=3D"ltr"><p style=3D"margin-top:0px;font-family:Helvetica,Arial,sans=
-serif;font-size:14px;line-height:19px">Hi folks,</p><p style=3D"font-famil=
y: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 serve=
r 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 pag=
e 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 te=
st site (Non-farcry) with only one page request to the database I&#39;m hav=
ing problem with, and I can get the response back without issue.</p><p styl=
e=3D"font-family:Helvetica,Arial,sans-serif;font-size:14px;line-height:19px=
">From the debugger information I can see C:/wwwroot/mysite/farcry/core/<wb=
r>tags/farcry/_<wbr>farcryApplicationInit.cfm took long time to execute:<br=
><br></p><p style=3D"font-family:Helvetica,Arial,sans-serif;font-size:14px;=
line-height:19px">Total Time Avg Time Count Template</p><p style=3D"font-fa=
mily:Helvetica,Arial,sans-serif;font-size:14px;line-height:19px"><span styl=
e=3D"font-size:small"><font color=3D"#ff0000"><b>192387ms 192387ms 1 C:/www=
root/mysite/farcry/core/<wbr>tags/farcry/_<wbr>farcryApplicationInit.cfm 14=
1380ms 1285ms 110 C:/wwwroot/mysite/farcry/core/<wbr>packages/fourq/_fourq/=
getData.<wbr>cfm 42486ms 42486ms 1 CFC[C:/wwwroot/mysite/farcry/<wbr>core/p=
ackages/security/<wbr>security.cfc | init() ]</b></font></span></p><p style=
=3D"margin-top:0px;font-family:Helvetica,Arial,sans-serif;font-size:14px;li=
ne-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 Co=
ldFusion 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-heigh=
t:19px">Could anyone share some thoughts on this? I got no clue at the mome=
nt=C2=A0<img src=3D"http://discourse.farcrycore.org/images/emoji/emoji_one/=
frowning.png?v=3D0" title=3D":frowning:" alt=3D":frowning:" style=3D"border=
:0px;vertical-align:middle;width:20px;min-height:20px;max-width:690px;max-h=
eight:500px"></p><p style=3D"font-family:Helvetica,Arial,sans-serif;font-si=
ze:14px;line-height:19px">Thanks,<br>Xiaofeng</p><div><br></div>-- <br><div=
>Best regards,<br><br>Xiaofeng,^_^</div>
</div>
</blockquote></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 />

------=_Part_5135_149569704.1445437675514--
------=_Part_5134_1926908327.1445437675513--