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.
