I'm looking for information regarding performance tuning CFMX using CF Administrator. Some things I'm unsure of that I'd like to find info on: Caching > Trusted Cache: ---- what's the performance gain here? Does this mean every time I change code I have to uncheck this and run the template, then check it again? Java and JVM Settings > Max Memory Size: ---- what's a good max value if there's say 1024MB RAM on the server? Plus any other general performance and tuning tips for working with SQL Server databases. We added 1/2 million records to our database last night and performance on some searches has slowed to a crawl. I know part of the issue can be fixed using stored procedures, but some of the variable queries are just painful. Will Full-Text indexing on SQL Server help speed up these searches? Thanks, Joshua Miller Head Programmer / IT Manager Garrison Enterprises Inc. www.garrisonenterprises.net <http://www.garrisonenterprises.net/> [EMAIL PROTECTED] (704) 569-9044 ext. 254 ************************************************************************ ************* Any views expressed in this message are those of the individual sender, except where the sender states them to be the views of Garrison Enterprises Inc. This e-mail is intended only for the individual or entity to which it is addressed and contains information that is private and confidential. If you are not the intended recipient you are hereby notified that any dissemination, distribution or copying is strictly prohibited. If you have received this e-mail in error please delete it immediately and advise us by return e-mail to <mailto:[EMAIL PROTECTED]> [EMAIL PROTECTED] ************************************************************************ *************
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
