Dave Watts wrote: >> Our application mix that needs the performance runs mostly >> between midnight and mid-morning, and is a suite of CF >> scripts that interact with webservices from the major search >> engines. Lots of XML parsing and processing with lots of >> database activity to store the data. Some of the XML files >> are large, and therefore use up a lot of JVM when being >> processed (since at some point in time there needs to be a >> copy of both the CFHTTP data returned from the webservice as >> well as the structure being created by the xmlParse >> function). We have a pretty well configured SQL 2000 server, >> although the production could admitedly use some tuning. > > Why are you doing this XML parsing from CF at all?
This question can easily be extended to the other parts of you application as well. For instance, why are you using cfhttp to download files when surely wget can do that much more efficiently? We really need a much better picture of your performance problems before we can make recommendations. For all we know, your real bottleneck is network latency or the fact that no matter how much CPU power you throw at it CF can only generate 64 UUIDs per second. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284772 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
