Re: VB.NET vs CFMX tick count distribution?

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Samuel R. Neff (blinex_at_newsgroup.nospam)
Date: 01/01/05 

Date: Sat, 01 Jan 2005 13:23:26 -0500

CFMX doesn't support OLEDB, it supports JDBC and ODBC via the JDBC
bridge. However, it also supports MSSQL via a native JDBC driver
(pure Java, no intermediary code).

Similarly, .NET supports MSSQL through a native driver without using
either ODBC or OLEDB. You should use the native mssql driver and not
odbc with .NET.

HTH,

Sam

On Sat, 1 Jan 2005 11:28:32 -0500, "Brett" <no@spam.net> wrote:

>>Whenever you use non-native technologies you're going to see some incrased
>> variability and decreased performance
>
>I can understand decreased performance in the above scenario but why
>variability? Say I have a COM object fully written in VB.NET. I make the
>call from VB.NET to the object, are you saying there will be no variability?
>Why?
>
>Thanks. The code I posted downloads messages, loops through each message
>and inserts it into an SQL Server via stored procedures. VB.NET can
>establish a native ODBC interface through the .sqlclient driver but CF must
>use OLEDB or the generic SQL driver. In the case, should VB.NET always have
>the performance advantage for the same code?
>
>CF will never be as optimized to run on a Windows server and interface with
>SQL Server as VB.NET will. For this one reason, CF will lag in performance
>compared to VB.NET. I will try the CFMX code with cfpop post my results.
>
>Brett
>

Relevant Pages

  • Re: Detecting a broken connection
    ... I think the idea was to make a JDBC/ODBC driver easier to implement for all ODBC ... have a JDBC driver but do have an ODBC one. ... Lee Fesperman, FFE Software, Inc. ...
    (comp.lang.java.databases)
  • BindException (Address already in use) when connecting to MSSQL
    ... I'm experiencing a problem with JDBC and MSSQL 2000, ... I'm using JNetDirect's JDBC driver, but I've also tried the MS driver, ...
    (comp.lang.java.programmer)
  • Re: VB.NET vs CFMX tick count distribution?
    ... it supports JDBC and ODBC via the JDBC ... it also supports MSSQL via a native JDBC driver ... Isn't this still slower than the .sqlclient driver VB.NET will use, ...
    (microsoft.public.dotnet.languages.vb)
  • Problem with mssql jdbc
    ... I can't connect with jdbc for mssql. ... } catch (ClassNotFoundException e) { ... [SQLServer 2000 Driver for JDBC]Error ...
    (comp.lang.java.programmer)
  • Re: Jdbc connect to a Plain text file
    ... > use of external drivers or odbc? ... To use JDBC, you need a driver. ... driver that comes with the JRE is the JDBC-ODBC bridge. ...
    (comp.lang.java.programmer)