Good clarifications Kai. Always nice to cut through some of the marketing spin.
Carl, swapping out your JDBC drivers would be a fairly small amount of effort to see if it gives you any performance improvements. You could just run your regression tests over your app after the swap and see the footprint is lower. On Nov 24, 2:25 pm, Kai Koenig <k...@koeni.de> wrote: > Just a quick note to make a few things clear: > > - the type doesn't reflect on the quality. E.g. a type 4 driver is not better > than a type3 driver and a type5 driver not necessary better than a type4 > driver. They just do things in different ways. I just want to avoid that the > type is seen as a quality indicator. > > - there is no such thing as jdbc type5 drivers. The product Carl is pointing > to is nothing but a vendor-specific implementation of a type4-driver with a > few new and different features that Data Direct have decided to give as much > marketing spin as they can and call it "type5". > > - the features in that "type5" driver that appear to make them be miles ahead > are mostly irrelevant from a CF point of view imho. For Java developers - > looks certainly interesting. But a lot of the stuff this driver promises to > fix is dealt with within CF anyway so that I think it won't be relevant for > CF devs. > > - I haven't looked at the price tag, but I assume the DD drivers don't come > free of charge. > > Happy to be proven wrong in all of my points though :-) > > Cheers > Kai > > > > > Hello Pat, > > > I use the divers built in CF. The JDBC divers in CF8/9 are type4. I > > see datadirect has released jdbc type5 drivers: > > >http://web.datadirect.com/products/jdbc/index.html > > > Regards, Carl. > > >> I haven't checked in a while but the jtds driver (http:// > >> jtds.sourceforge.net/) used to be faster than default JDBC driver CF > >> come's with for MSSQL > > > -- > > You received this message because you are subscribed to the Google Groups > > "cfaussie" group. > > To post to this group, send email to cfaus...@googlegroups.com. > > To unsubscribe from this group, send email to > > cfaussie+unsubscr...@googlegroups.com. > > For more options, visit this group > > athttp://groups.google.com/group/cfaussie?hl=en. > > -- > Kai Koenig - Ventego Creative Ltd > ph: +64 4 476 6781 - mob: +64 21 928 365 / +61 435 263 414 > web:http://www.ventego-creative.co.nz > blog:http://www.bloginblack.de > twitter:http://www.twitter.com/agentK > > !!! New AU mobile number !!! > -- -- You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.