> This is through experience; try and run some CPU intensive > processes and see how badly the DataDirect driver performs
I'm not sure what you mean by "CPU-intensive", since most of the work is being done by the database. Are you simply referring to large recordsets? If so, are you also saying that fetching those same recordsets using inline SQL performs better? Again, this has not been my experience at all (so far - perhaps I've been lucky). Also, when you say "large recordsets", how much data are you talking about? Again, I'm not trying to be critical - you may very well be right about this. > - it a good driver for sure, but it ain't the best, in fact > I am yet to find a really good one - I haven't really tested > the BD connector - maybe that it better. BlueDragon on Java uses New Atlanta's own JTurbo driver to talk to SQL Server, I think. This is supposed to be a very good driver, but I have very little experience with it so far. On .NET, of course, I suspect they simply use the native ADO.NET stuff provided by Microsoft. > I am also not sure if its CF or the DataDirect driver on this > one but if you try and return multiple recordsets (BLOB/CLOB) > it will simply stop responding - seems like on an SP with > around 8-10 large recordsets returned it will just fall over. That may also be the case. I have no idea, simply because I've never had a need to have a single procedure returning that many recordsets. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:4:222749 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
