On Thu, Feb 12, 2009 at 10:22 AM, Gaulin, Mark <mgau...@globalspec.com> wrote: > > Say, what was the deal with going "back to using the regular SQL Server > JDBC" and "my queries are flying"?
My fusion reactor wrapper driver was misconfigured... I'd accidentally referred to the FR2.0 documentation for setting it up... select method was set to cursor instead of direct... unicode support was enabled which led to some data type mismatches on a query that handles user authentication on every single page,, and maxpooledstatements apparently defaults to 0 if you don't specify it in the jdbc url so it was recompiling every query. I could probably go back to the fusionreactor wrapper driver now that I know how to properly configure it, but I'm just sticking with the standard driver until I need to do more jdbc monitoring.. -- 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:319277 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4