If I used a DNS connection is more fast

[scubaman]

I´m try using a searching into my site, but have 972.000 registers... So I ask what is more fast?

DNS Connection or Less connection.

To get more performace in SQL Server

Thanks

Luciano

 

[culshaja]

It is more efficient to use the SQLOLEDB provider for ADO. If you use a Connection object rather than pass a connection string then the connection will be cached/shared.
The OLEDB provider is also more efficient than the corresponding ODBC driver.

James James Culshaw
jculshaw@active-data-solutions.co.uk

http://www.active-data-solutions.co.uk

http://www.brainbench.com/transcript.jsp?pid=193305

 

[wushutwist]

The most efficient connection is to use, as James said, ADO objects. ADO is just a wrapper for OLEDB. Write your connection in VB and create it as a ActiveX DLL, that way the code is already compliled and optimized. Then you can call it from the ASP page.


Wushutwist


Sun Certified Java 2 Programmer

 

[unicorn11]

even i belive the atx dll will deliver the best speed in data connection

regards :

Unicorn11
abhishek@tripmedia.com

ENJOY !!!!!!!!!!