DB-Library, ODBC, Borland's SQL Links 
Author Message
 DB-Library, ODBC, Borland's SQL Links

Hello.  I need to learn more about the strengths and weaknesses of the
interfaces availible for SQL Server.  Efficiency both in terms of
speed and memory are very important to the c/s system we are
developing.

Does anyone know of helpful studies or papers that compare the
performance of DB-Library to ODBC?  

We are considering developing client applications using Borland Delphi
and/or C++Builder.  Therefore we are looking into using Borland's SQL
Links native interface.  Does anyone know how this compares to using
straight DB-Library calls?  How does SQL Links compare to the ODBC-
via-Borland Database Engine interface?

Also, does anyone know it is possible (or desirable) to use DB-Library
within Borland C++Builder?

Thanks in advance for any pointers.
Jake.



Sat, 09 Oct 1999 03:00:00 GMT
 DB-Library, ODBC, Borland's SQL Links

It depends on how deep your app. need to get with SQL. From my experience
DBLIB
is a much faster and more powerful than ODBC, but of course ODBC will work
with more than just MS-SQL.

If you use DBLIB I can see while you cannot use it with Borland C++, DBLIB
is just a bunch of DLL calls, you link to its import library and use its C
header file.

If you do C/C++ and only use MS-SQL like me then DB-LIB would be a better
choice.

Hung Do.



Quote:
> Hello.  I need to learn more about the strengths and weaknesses of the
> interfaces availible for SQL Server.  Efficiency both in terms of
> speed and memory are very important to the c/s system we are
> developing.

> Does anyone know of helpful studies or papers that compare the
> performance of DB-Library to ODBC?  

> We are considering developing client applications using Borland Delphi
> and/or C++Builder.  Therefore we are looking into using Borland's SQL
> Links native interface.  Does anyone know how this compares to using
> straight DB-Library calls?  How does SQL Links compare to the ODBC-
> via-Borland Database Engine interface?

> Also, does anyone know it is possible (or desirable) to use DB-Library
> within Borland C++Builder?

> Thanks in advance for any pointers.
> Jake.



Sat, 09 Oct 1999 03:00:00 GMT
 DB-Library, ODBC, Borland's SQL Links



Quote:
> <snip>
> Does anyone know of helpful studies or papers that compare the
> performance of DB-Library to ODBC?  

> We are considering developing client applications using Borland Delphi
> and/or C++Builder.  Therefore we are looking into using Borland's SQL
> Links native interface.  Does anyone know how this compares to using
> straight DB-Library calls?  How does SQL Links compare to the ODBC-
> via-Borland Database Engine interface?

> Also, does anyone know it is possible (or desirable) to use DB-Library
> within Borland C++Builder?

>The differences between these are apparent to anyone whose used all three:

DB library --       Fastest        ,  Most Robust,   Most Durable,  Least
Portable
Borland IDAPI -- Next Fastest,  Robust        ,   Durable         ,   More
Portable ( to other DBMSs)
ODBC --            Much Slower,  Not Robust  ,   Brittle            ,  
Most Portable

Hope this helps:



Tue, 12 Oct 1999 03:00:00 GMT
 DB-Library, ODBC, Borland's SQL Links

Quote:

> >The differences between these are apparent to anyone whose used...

It's exact truth !!!
We've built an application in GUPTA SQL Windows to MS SQL Server.
Application is universal so we can use the both ways, either DB Library
(called SQL Router in Gupta) or ODBC Driver.
When we connect our application through ODBC it's much more slower
(sometimes maybe ten times) than using DB Library. The more clients are
connected to SQL Server through ODBC the slower is client application.
When you're connected through DB-Library you don't have any problems
(ODBC is probably fast only when you work alone with server).

Another problem is that we still must rewrite our apps. Because each new
version of ODBC driver (they are the patches fixing bugs) is not
compatibile with previous. We must debug and investigate why a command
worked good in one version doesn't work in upgrade.
There's lot of absurd, undocumented limitations in ODBC API and lot of
bugs as well. Sometimes a SELECT doesn't work but when you rewrite WHERE
condidion in different order it suddenly works. You can write a "batch
sequences" using DB-Library, but when you connect through ODBC...forget
it. I could mention many many examples.

Now Gupta has a new 32bit product called "Centura Team Developer" but
there is no DB-Library support. Only ODBC. So we cannot move to 32bit
client, Cause if conecting through ODBC driver our users will kill us.
Well we keep compatibility and wait for for a good times...

I hope it opens somebody's eyes,
Vladimir.



Tue, 12 Oct 1999 03:00:00 GMT
 DB-Library, ODBC, Borland's SQL Links

Beg to disagree. ODBC has come a long and is certainly not brittle. others
please comment!!!



Quote:



> > <snip>
> > Does anyone know of helpful studies or papers that compare the
> > performance of DB-Library to ODBC?  

> > We are considering developing client applications using Borland Delphi
> > and/or C++Builder.  Therefore we are looking into using Borland's SQL
> > Links native interface.  Does anyone know how this compares to using
> > straight DB-Library calls?  How does SQL Links compare to the ODBC-
> > via-Borland Database Engine interface?

> > Also, does anyone know it is possible (or desirable) to use DB-Library
> > within Borland C++Builder?

> >The differences between these are apparent to anyone whose used all
three:

> DB library --       Fastest        ,  Most Robust,   Most Durable,  Least
> Portable
> Borland IDAPI -- Next Fastest,  Robust        ,   Durable         ,  
More
> Portable ( to other DBMSs)
> ODBC --            Much Slower,  Not Robust  ,   Brittle            ,  
> Most Portable

> Hope this helps:



Tue, 12 Oct 1999 03:00:00 GMT
 DB-Library, ODBC, Borland's SQL Links

Quote:

> Hello.  I need to learn more about the strengths and weaknesses of the
> interfaces availible for SQL Server.  Efficiency both in terms of
> speed and memory are very important to the c/s system we are
> developing.

> Does anyone know of helpful studies or papers that compare the
> performance of DB-Library to ODBC?...

I don't know such studies but I can give you some information.

We've built an application in GUPTA SQL Windows to MS SQL Server.
Application is universal so we can use the both ways, either DB Library
(called SQL Router in Gupta) or ODBC Driver.
When we connect our application through ODBC it's much more slower
(sometimes maybe ten times) than using DB Library. The more clients are
connected to SQL Server through ODBC the slower is client application.
When you're connected through DB-Library you don't have such problems.

Another problem is that we still must rewrite our apps. Because each new
version of ODBC driver (they are the patches fixing bugs) is not
compatibile with previous. We must debug and investigate why a command
worked good in one version doesn't work in upgrade.
There's lot of limitations in ODBC API. Sometimes a SELECT doesn't work
but when you rewrite WHERE condidion in different order it suddenly
works. You can write a "batch sequences" using DB-Library, but when you
connect through ODBC...it does not work. I could mention many many
examples.

Now Gupta has a new 32bit product called "Centura Team Developer" but
there is no DB-Library support. Only ODBC. So we cannot move to 32bit
client, 'cause if conecting by ODBC driver our users won't be happy .
Well we keep compatibility and wait for a better ...

I hope it helps you,
Vladimir.



Fri, 15 Oct 1999 03:00:00 GMT
 
 [ 6 post ] 

 Relevant Pages 

1. Linking DB-Library with Borland C++

2. Using DB Library with Borland's C++ Builder

3. SQL Svr 7 and Borland's SQL Links for Paradox for DOS 4.5

4. Need equivalent of Sybase's DBSETLAPP DB-Library call for ODBC

5. Need equivalent of Sybase's DBSETLAPP DB-Library call for ODBC

6. API Differences between Borland's DB Framework 3.01 and DB Engine 2.0

7. ODBC Borland SQL Links - Sybase ISQL.EXE

8. Sybase DB-Library using Borland v1.5 for OS/2

9. Latest Versions: Net-Library, DB-Library, ODBC Driver

10. Borland Paradox Library or any OFS database library for the PC

11. Microsoft's OLE DB Simple Provider 1.5 Library isn't cutting it :(

12. ODBC OLE DB and DB-Libraries


 
Powered by phpBB® Forum Software