On Thu, Feb 12, 2009 at 11:34 AM, Brad Wood <[email protected]> wrote: > >> resolving the way my database driver was configured >> helped clear up a lot of problems by reducing the # of reads we were >> doing. > > @Rick, can you provide any specifics on the above change? What did he > change? How did it reduce reads?
Sorry for having two threads on this issue but here are the specifics... Unicode support was enabled in the FR driver, and I'd created a member_sessions table with a "char" field as the primary key.. not nchar. So for that reason, the indexes weren't working very well because of the data type mismatch... SQL ended up having to do a convert() and ended up doing an index scan instead of an index seek I guess.. something like that. So I disabled unicode support and then last night I converted my CHAR fields to NCHAR and re-enabled unicode support in the driver. -- Rick Root New Brian Vander Ark Album, songs in the music player and cool behind the scenes video at www.myspace.com/brianvanderark ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319279 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
