RE: Embedded SQL vs. C/C++ with ODBC vs. SQLDBC

Hello John,

that native interface, SQLDBC, was created to be a foundation for 
future versions of other interfaces/tools, for now the new Perl DBD module 
for MaxDB as the first interfaces, and for example the sqlcli command line
tool or the MaxDB Proxy that makes it possibly for a MaxDB to masquerade
as a MySQL server.
 
It was published too as separate package because of it is necessary for
building the new DBD Perl module from CPAN.

Although this is more a step of internal consolidation, SQLDBC could possibly
be useful for someone writing a native application, or some other driver 
(there was a guy writing some DBExpress driver for Delphi, IIRC), and although
its a kind of propietary interface, we think it can be helpful, so why not 
publishing it?

All existing 'native' (i.e. C/C++) interfaces base on the runtime
library of the C Precompiler, which has a longer history. 

>From the performance aspect, there should be at least no visible 
difference between SQLDBC and the Precompiler (the goal is of course, 
that SQLDBC is faster). However we are always interested in hearing about
how it performs, as we don't expect to be perfect, especially with a 
new piece of software :-)

Regards
Alexander Schröder
SAP DB, SAP Labs Berlin 

> -----Original Message-----
> From: John L. Singleton [mailto:jsinglet@xxxxxxxxxxxxxxxxx]
> Sent: Thursday, May 27, 2004 2:22 PM
> To: maxdb@xxxxxxxxxxxxxxx
> Subject: Embedded SQL vs. C/C++ with ODBC vs. SQLDBC
> 
> 
> Hello,
> 
> I've noticed the availability of a new download for MaxDB, 
> SQLDBC.  I'm 
> trying to understand how SQLDBC fits into the picture. It 
> seems to be a 
> native C++ interface to MaxDB. However, I've read in several 
> different 
> places, that if one uses ODBC directly via C/C++, that in MaxDB, the 
> implementation is native, and therefor results in no performance hit. 
> Was it SQLDBC behind this all along?
> 
> Also, with regard to Embedded SQL vs. SQLDBC: which one is faster? Is 
> the code that the precompiler generates essentially the same as the 
> SQLDBC interface?
> 
> 
> Best,
> 
> JLS
> 
> -- 
> MaxDB Discussion Mailing List
> For list archives: http://lists.mysql.com/maxdb
> To unsubscribe:    
http://lists.mysql.com/maxdb?unsub=alexander.schroeder@xxxxxxx

--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/maxdb?unsub=gcdm-maxdb@xxxxxxxxxxx