System DSN Faster Than File DSN!

System DSN Faster Than File DSN!

Post by Arpa » Mon, 27 Jun 2005 15:29:41


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
 
 
 

System DSN Faster Than File DSN!

Post by Jon » Mon, 27 Jun 2005 20:40:59

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!

--
Jon
XXXX@XXXXX.COM
Look at that dead pixel on your screen! *SLAP* Gotcha!

 
 
 

System DSN Faster Than File DSN!

Post by Jon » Mon, 27 Jun 2005 20:48:26

Actually I'd be interested to read that article from MS because I cannot
find anything that suggest one is faster than the other. Here is an article
that explains the differences and perhaps favours file-DSNs due to there
portability
http://www.yqcomputer.com/

--
Jon
XXXX@XXXXX.COM
Look at that dead pixel on your screen! *SLAP* Gotcha!
 
 
 


System DSN Faster Than File DSN!

Post by Bob Barrow » Tue, 28 Jun 2005 00:06:58


Much of the registry is cached in RAM, so the information is quickly
available.

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

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"
 
 
 

System DSN Faster Than File DSN!

Post by larrybud20 » Wed, 29 Jun 2005 04:28:28

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

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

System DSN Faster Than File DSN!

Post by Arpa » Wed, 29 Jun 2005 11:35:14

Visit http://www.yqcomputer.com/ ;en-us;258939 to
read the KB article Jon. It's the very 1st point listed under the topic
'Additional items to consider' in that article.

Thanks to everyone for their input.

Regards,

Arpan
 
 
 

System DSN Faster Than File DSN!

Post by Jon » Mon, 04 Jul 2005 01:01:24

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.

--
Jon
XXXX@XXXXX.COM
Look at that dead pixel on your screen! *SLAP* Gotcha!