Page 1 of 1
Benefits to Direct and Client Connection Modes
Posted: Sat 28 Jun 2008 19:35
by MZmuda
Can someone tell me the benefits of Direct Connection mode vs Client Connection mode?
I understand the mechanics (Direct Connect bypasses the mylib.dll [or whatever] file(s), etc...) but what are the BENEFITS of doing it this way?
Which way is faster? Which way has the most secure connection? Which way uses the least bandwidth, etc...
Anything you can think of, I'd like to hear about.
Thanks -
Mike Z.
Re: Benefits to Direct and Client Connection Modes
Posted: Sun 29 Jun 2008 01:36
by eduardosic
MZmuda wrote:Can someone tell me the benefits of Direct Connection mode vs Client Connection mode?
I understand the mechanics (Direct Connect bypasses the mylib.dll [or whatever] file(s), etc...) but what are the BENEFITS of doing it this way?
Which way is faster? Which way has the most secure connection? Which way uses the least bandwidth, etc...
Anything you can think of, I'd like to hear about.
Thanks -
Mike Z.
see:
http://www.devart.com/mydac/
"Using MyDAC in Direct mode provides the optimal transfer route"
i like the directMode, easy to deploy the application, no external dll's
without conflicts with dll' s of different versions.
I believe that the communication in direct mode is more faster.
certainly the Devart's Team goes to clarify with more informations.
Go to wait.

Posted: Sun 29 Jun 2008 09:17
by swierzbicki
I'm not sure but wasn't any specific licence issue if using libmysql.dll ?
I'm using direct connection mode since it behaves the same way as ibmysql.dll does.
Posted: Tue 01 Jul 2008 06:45
by Dimon
One of the base benefits of using the Direct mode is working without using MySQL client library (libmysql.dll), at that perfomance and stability is increased. The connection security and other behaviour is the same with the Client mode.