Which is faster, DSN or DSN-less for connecting to a database? I have been using DSN, are there any specific advantages of using DSN-less? It seems no matter where I look, every one seems to favor one or the other.
Printable View
Which is faster, DSN or DSN-less for connecting to a database? I have been using DSN, are there any specific advantages of using DSN-less? It seems no matter where I look, every one seems to favor one or the other.
DSN is faster, but dsn-less is good if your db's are on a separate server and you don't know the full path or you can access it to install a dsn. thats what i've heard anyway.
I've always read that DSN-Less connections are faster, as a DSN connection requires a trip to the registry on each connection meaning when large numbers are being performed you suffer more of a performance hit?
DSN-less connections seem to me to be easier to maintain. I can upload the database without needing physical access to add/change the DSN.
Josh