Difference in speeds between ODBC and OLE DB

[Welshbird]

Hi,

I have a VB app looking at an SQL database using the database running on MSDE. At the moment its connecting via an ODBC connection, but the speed of data coming back is very slow. The data source is local (ie on the same work station) but I'm just wondering if I would have been better off to use and OLE DB connection string?

Any ideas anyone?

Thanks in advance. Fi.

 

[jjgraf]

Not really, you pick up a bit but not much.

VB is just not designed to be data away. ADO is by far one of the slowest ways to access data in the world.

let me give you an example.

I ended up in an e-mail one-up-menship which is better VB or Foxpro I won.

Using the Northwind database, ole-db, DNS-Less connection Foxpro out ran VB by 35 times.

ADO is just dog/hog on a system.


Something you can try to increase your speed

check your memory usage the min is 128 on sql

processor min 300 mhz

defrag harddrive

Use indexes on key fields if knone are being used