Stephen said: > The most common reason for this performance problem is: > 1) migration from CF5 (unicode datasource setting gets set to > 'true' - table scan against varchar - known issue - see #2) > 2) having "Enable Unicode for data sources configured for > non-Latin characters" ON.
Is this problem specific to SQL Server or does it affect other DBs? I don't find this setting anywhere in our CF Admin (7.0.2) or our data source configuration screens. We're using DB2 on z\OS and Oracle 10g. Thanks! George ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270759 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
