Board index » delphi » ODBC 12x faster than BDE 5.01 MSSQL driver??

Lindsay Reichmann

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

ODBC 12x faster than BDE 5.01 MSSQL driver??

Is the BDE 5.01 MSSQL driver really twelve times slower than ODBC for
fetching records?  Or are we doing something wrong?

We are running a very simple test that opens a query on a 30000-row table
and calls TQuery.Next until EOF is True.  The results:

BDE 5.01 MSSQL Driver: 300 rows/second
ODBC: 3700 rows/second

We must be doing something wrong, right?  All of our connection settings are
default (e.g., no LANGDRIVER specified), except that we set TDS PACKET SIZE
to 4096.

(Other details: Delphi 4 C/S w/ Update Patch #2; connecting via 100Base-T
LAN to SQL Server 6.5 w/latest SP on NT Server 4.)

Thanks in advance,

Lindsay

 
Ian Mar{*word*249}

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:ODBC 12x faster than BDE 5.01 MSSQL driver??


I've heard from MS people that SQL Server 7 native language is OLE-DB, and
that DBLibrary (on which SQL Link is built) have been rebuilt around the
latest MS toy. Rumours has it... I hope Inprise will develop a native
interface to OLE DB as soon as possible. I know nothing about any OLE
DB-based datasets, currently.
Ian
Ray Port

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:ODBC 12x faster than BDE 5.01 MSSQL driver??


I don't know about 12x faster, but ODBC is usually faster for MS
SQLServer than native drivers.  The MS ODBC driver for SQLServer
bypasses the middleware layer to go directly to the database and, I've
been told, is MS's own preferred method for accessing MS SQLServer.

On Fri, 22 Jan 1999 16:17:36 -0600, "Lindsay Reichmann"

Quote
<lreichm...@sequestresources.com> wrote:
>Is the BDE 5.01 MSSQL driver really twelve times slower than ODBC for
>fetching records?  Or are we doing something wrong?

>We are running a very simple test that opens a query on a 30000-row table
>and calls TQuery.Next until EOF is True.  The results:

>BDE 5.01 MSSQL Driver: 300 rows/second
>ODBC: 3700 rows/second

>We must be doing something wrong, right?  All of our connection settings are
>default (e.g., no LANGDRIVER specified), except that we set TDS PACKET SIZE
>to 4096.

>(Other details: Delphi 4 C/S w/ Update Patch #2; connecting via 100Base-T
>LAN to SQL Server 6.5 w/latest SP on NT Server 4.)

>Thanks in advance,

>Lindsay

================================================
Ray Porter
Applications Analyst Programmer
Administrative Information Services, UNC-CH
Phone: 966-5878
email: ray_por...@unc.edu
       dra...@email.unc.edu
Home Page: http://www.unc.edu/~dragon/

"Meddle not in the affairs of dragons,
for you are crunchy and taste good with ketchup."

Lindsay Reichman

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:ODBC 12x faster than BDE 5.01 MSSQL driver??


Thanks for the reply -- it turns out the 12x difference only occurs when our
test application is run from the IDE.  When the executable is run directly,
the SQL Links MSSQL driver performs very nicely compared to ODBC.

Sorry for any confusion.

Quote
Ian Mar{*word*249}s wrote in message <78cr00$lh...@forums.borland.com>...
>I've heard from MS people that SQL Server 7 native language is OLE-DB, and
>that DBLibrary (on which SQL Link is built) have been rebuilt around the
>latest MS toy. Rumours has it... I hope Inprise will develop a native
>interface to OLE DB as soon as possible. I know nothing about any OLE
>DB-based datasets, currently.
>Ian

Lindsay Reichman

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:ODBC 12x faster than BDE 5.01 MSSQL driver??


Thanks for the reply -- you were right to question the "12x faster" part.
It turns out the 12x difference occurs only when our test application is run
from the IDE.  When the executable is run directly, the SQL Links MSSQL
driver performs very nicely compared to ODBC.

Sorry for any confusion.

Quote
Ray Porter wrote in message <36ac6a2d.1861...@forums.borland.com>...
>I don't know about 12x faster, but ODBC is usually faster for MS
>SQLServer than native drivers.  The MS ODBC driver for SQLServer
>bypasses the middleware layer to go directly to the database and, I've
>been told, is MS's own preferred method for accessing MS SQLServer.

>On Fri, 22 Jan 1999 16:17:36 -0600, "Lindsay Reichmann"
><lreichm...@sequestresources.com> wrote:

>>Is the BDE 5.01 MSSQL driver really twelve times slower than ODBC for
>>fetching records?  Or are we doing something wrong?

>>We are running a very simple test that opens a query on a 30000-row table
>>and calls TQuery.Next until EOF is True.  The results:

>>BDE 5.01 MSSQL Driver: 300 rows/second
>>ODBC: 3700 rows/second

>>We must be doing something wrong, right?  All of our connection settings
are
>>default (e.g., no LANGDRIVER specified), except that we set TDS PACKET
SIZE
>>to 4096.

>>(Other details: Delphi 4 C/S w/ Update Patch #2; connecting via 100Base-T
>>LAN to SQL Server 6.5 w/latest SP on NT Server 4.)

>>Thanks in advance,

>>Lindsay

>================================================
>Ray Porter
>Applications Analyst Programmer
>Administrative Information Services, UNC-CH
>Phone: 966-5878
>email: ray_por...@unc.edu
>       dra...@email.unc.edu
>Home Page: http://www.unc.edu/~dragon/

>"Meddle not in the affairs of dragons,
>for you are crunchy and taste good with ketchup."

John Kaste

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:ODBC 12x faster than BDE 5.01 MSSQL driver??


According to the R&D people I met with at MS, OLEDB, ODBC, and DBLib all
access SQL Server 7 from the same layer.

Running applications in the IDE in debug mode will always be significantly
slower than running it out of the IDE.  Also, the IDE takes system resources
as well.

Other Threads

1. BDE 5.01 - MSSQL7.0 ODBC Driver - sysobjects table

2. BDE 5.01 and MSSQL 7.0

3. Extreme memory usage using image BLObs, MSSQL/BDE 5.01

4. General SQL error with image BLObs, MSSQL+D4+BDE 5.01

5. ODBC 3.5 DAO faster than BDE 4.51 using native access driver

6. Problems using BDE 5.01 and Oracle 8 drivers reading Oracle 7.3 databases

7. definition in oracle driver of bde 5.01

8. Slow performance using BDE 5.01 with some language drivers

9. sybase driver missing from merge module installation of BDE 5.01

10. Language drivers, BDE 5.01 and Config\System\INIT\LANGDRIVER