Which is Faster 3

[BettyM]

Is it faster to connect natively or via ODBC to a Pervasive SQL 2000 database in CR 9?

 

[SurfingGecko]

Think of this in terms of layers.

Direct to Pervasive eliminates the ODBC layer between the report and the source, but it is replaced with the Perv client.

It all will come down to network traffic, but you may see a bit of a boost in Native.

Cheers

SurfingGecko
SurfingGeckoSoftware.com

 

[kenhamady]

Too many factors to make this an easy answer. I would try it both ways (then let us know if you find a significant difference).

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Guide to Crystal in VB

http://www.kenhamady.com/

- tek@kenhamady.com

 

[synapsevampire]

Native is billed as faster by CR.

Since Microsoft no longer supports ODBC, I would use either Native or OLE DB.

-k

 

[chelseatech]

I found a situation where ODBC was a lot faster than native. Selecting a single record from 2000 records in an Access MDB on a remote server, traversed each record using native access, but was instant using ODBC. ODBC sends the SQL to the remote machine.

The MDB on a local machine, was faster than the ODBC.

So you have to try it an see.

Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm