Hi Sean, I also created a thread in Discourse for this.
http://discourse.farcrycore.org/t/farcry-6-2-request-timeout-issue/482 Cheers, Xiaofeng On Thu, Oct 22, 2015 at 1:27 AM, Sean Coyne <[email protected]> wrote: > 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: [email protected] > To unsubscribe, email: [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 [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- Best regards, Xiaofeng,^_^ -- You received this message cos you are subscribed to "farcry-dev" Google group. To post, email: [email protected] To unsubscribe, email: [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 [email protected]. For more options, visit https://groups.google.com/d/optout.
