> It's taking 391ms for the page to render... > > This is on a dedicated multi-CPU box running at 10% CPU utilization, > with a dedicated SQL Server on the same machine. > > Any ideas
Yup. Turn off CF debugging. It is extremely inaccurate. There are far better tools out there for tracking runtime processing on CF servers. When a CF page has multiple includes and queries the built-in debugger does an extremely poor job of tracking it (it takes more time to run the debugger than the processes on that page, thus the inaccurate times). Turning this off will increase performance. You said you're running a high-end SQL application on the same box as ColdFusion. Do you have enough RAM? A common problem I see with people who start using FarCry is that they sometimes assume FarCry only needs a few megs of RAM to run because their other smaller CF apps that use SQL run just fine. However, what they often fail to realize is that this is a SQL-based application and that database servers require RAM to cache their data. For production boxes I prefer to run either 2GB or 4GB of RAM. Side note: Most of my clients use MSSQL and unfortunately MS SQL2k has a limitation of 2GB RAM. So I've asked many of them to increase to 4GB or better and to move to MS SQL 2k5. This is really only needed for very large sites though (usually 10,000+ pages). Please keep in mind that hardware settings aside you can do DB performance enhancements. Examples are DB clustering, FarCry caching, etc. Hope this helps, Jeff Coughlin Web Application Developer http://www.jeffcoughlin.com --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "farcry-dev" group. To post to this group, send email to farcry-dev@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/farcry-dev -~----------~----~----~----~------~----~------~--~---
