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 7 1821
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 wa*********@gmail.com
Look at that dead pixel on your screen! *SLAP* Gotcha!
"Arpan" <ar******@hotmail.com> wrote in message
news:11*********************@g14g2000cwa.googlegro ups.com... 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
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://msdn.microsoft.com/library/de...machinedsn.asp
--
Jon wa*********@gmail.com
Look at that dead pixel on your screen! *SLAP* Gotcha!
"Arpan" <ar******@hotmail.com> wrote in message
news:11*********************@g14g2000cwa.googlegro ups.com... 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
Arpan wrote: 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
--
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"
> 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!!! ;-)
Visit http://support.microsoft.com/default...b;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
Jon wrote: 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://msdn.microsoft.com/library/de...machinedsn.asp
-- Jon wa*********@gmail.com Look at that dead pixel on your screen! *SLAP* Gotcha!
"Arpan" <ar******@hotmail.com> wrote in message news:11*********************@g14g2000cwa.googlegro ups.com... 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
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 wa*********@gmail.com
Look at that dead pixel on your screen! *SLAP* Gotcha!
"Arpan" <ar******@hotmail.com> wrote in message
news:11**********************@g44g2000cwa.googlegr oups.com... Visit http://support.microsoft.com/default...b;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
Jon wrote: 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://msdn.microsoft.com/library/de...machinedsn.asp
-- Jon wa*********@gmail.com Look at that dead pixel on your screen! *SLAP* Gotcha!
"Arpan" <ar******@hotmail.com> wrote in message news:11*********************@g14g2000cwa.googlegro ups.com... > 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 > This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: DerekS |
last post by:
Hi,
I've been pulling my hair out trying to write a simple method to
programatically create a system DSN with all parameters on a remote machine.
I have ensured I have the correct permissions on...
|
by: anaphaxeon |
last post by:
I'm wondering if there are any scripting gurus out there that can help with my situation. Here goes...
So I've made this .NET application that manages an engineering firm's drawings, this...
|
by: Alan.Squires |
last post by:
Hi,
I need to create a DB2 system DSN programmatically. I need to set the
currentschema parameter to be equal to the appropriate database name. I
am able to create the DSN ok, but am unable to...
|
by: Rico |
last post by:
Hello,
Can anyone tell me, is there an easy way to 1) Check to see if a DSN already
exists and if not, create a system DSN for the back end?
Also, is there an easy way to use the SQL Server...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
| |