System DSN Faster Than File DSN!

A

Arpan

Microsoft, in one of its "Help & Support" pages on ADO, says that a
System DSN is three times faster than a File DSN. I find that a bit odd
for the simple reason that won't it be faster for a script to access a
file to get info about the database source than access the same info
from the registry which will be the case if a System DSN is used
instead of a File DSN?

I very well know that ultimately a DSN-less connection is the best!

I guess it isn't as simple as I think it out to be :)

Thanks,

Arpan
 
J

Jon

I presume a system DSN is "active" (so to speak) so the application can just
call the details, etc because they are readily available. meaning it won't
have to access the registry thus making faster than a file DSN.

Though this is just my theory!
 
B

Bob Barrows [MVP]

Arpan said:
Microsoft, in one of its "Help & Support" pages on ADO, says that a
System DSN is three times faster than a File DSN. I find that a bit
odd for the simple reason that won't it be faster for a script to
access a file to get info about the database source than access the
same info from the registry which will be the case if a System DSN is
used instead of a File DSN?

Much of the registry is cached in RAM, so the information is quickly
available.
I very well know that ultimately a DSN-less connection is the best!

I guess it isn't as simple as I think it out to be :)

Thanks,
Use neither. Use OLE DB instead of ODBC (assuming a native OLE DB provider
is available for your database).

Many of the pages you will find on the MS Support site are in dire need of
revision.

Bob Barrows
 
L

larrybud2002

Many of the pages you will find on the MS Support site are in dire need of
revision.

Bob Barrows

Well, what the hell are you doing here?? Hop to it!!! ;-)
 
J

Jon

Ah hah! Thanks for the link. Interesting read though I'm presuming it only
applies to IIS. I cannot notice much difference on other servers. Though I
may just have not noticed and it may have been. I'll bear the info in mind.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
473,731
Messages
2,569,432
Members
44,832
Latest member
GlennSmall

Latest Threads

Top