Benefits to Direct and Client Connection Modes

[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.

[eduardosic]

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.

[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.

[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.