Hi all,
> But shouldn't ODBC be awfully slow due to protocol overhead?
> When I compare the performance of mysql native and mysql odbc
> (sorry for comparing 'apples and oranges'....), odbc isn't a
> real alternative.
the purpose of any interface library (existing and future) is
a) translating the user API (e.g. ODBC, or that MySQL interface or whatever)
into something the database understands
(see http://sapdb.2scale.net/moin.cgi/NetworkProtocol)
if you are interested in these gory details ...)
b) provide the workaround for API features that aren't in the database itself
supported if necessary.
In both 'simple' and 'complicated' libraries the overhead for (a) is the same,
as this must be done anyway. Only in case (b) it is shown what the database
does support, and what is burdened to the client, or emulated somehow.
So I assume too that if you stick with features of ODBC that look like and
map nearly 1:1 to what can be found in that MySql API, you have hopefully
not that difference in performance ... you only have always to remember that
this driver is built atop of that 'simple' library.
The problem is not comparing apples with oranges, it is more the difficulty that
sometimes an apple must work and look like an orange :-) - not so easy, I think.
Coming back to SAP DB, there are not so many ODBC/JDBC features that require
large efforts in the client libraries. Most efforts go into synchronisation, and
into some other necessary bookkeeping (parameter binding etc.) but these are
not bulky performance killers ...
>
> Are there yet any more details on the native c++ that was
> mentioned on the list some time ago?!
>
No schedule so far. But as Thomas already wrote, ODBC may be based then
on it, so you will certainly find some features necessary for that
interface in there :-)
Finally, you are quite sure if you use ODBC, you will have a certain degree
on flexibility with it and, you have a documented and defined interface a lot
of people know.
Regards
Alexander Schr�der
SAP Labs Berlin
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
