We applied the new drivers and no difference in query speed. A query that takes less than 2 seconds on the SQL server takes almost 80 seconds on the CF server. The only difference between the new server and the old is that the old is CF 5 on merant and the new is CF 7 on the latest drivers. I'm thinking that setting the datasource to 'other' and doing a JDBC connection might be a solution if I can only find documentation on setting up a MS SQL jdbc connection. If you know of any docs, please let me know. Thanks
> On 7/16/05, Michael Dinowitz <[EMAIL PROTECTED]> wrote: > > I have a client who moved from CF 5 to CF 7 on Linux. Their DB is > SQL 7 and the queries are running much slower on CF 7 than they did on > 5. Has anyone seen anything like this in their sites and is there a > known solution? > > Thanks > > > > Have they applied the latest JDBC 3.4 drivers from Macromedia? > > http://www.macromedia.com/go/1a3c2ad0 > > Also, I've heard/read numerous times that Microsoft's own JDBC > drivers > are far superior to the packaged DataDirect drivers, though we're an > Oracle shop, so I don't have direct experience with this theory. > > Regards, > Dave. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:14:4002 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/14 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:14 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.14 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
