Suitability?

Thanny · Post by **Thanny** » Thu 10 Apr 2008 22:49

I have a Windows service that acts as a proxy between network clients and a MySQL database.

It's written in BCB6 (would be converted to BCB2007 for this), and currently uses ADO with MyODBC.

I'm trying to make it more reliable, and given that COM makes things pretty flaky in threads, I figured taking COM out of the equation would be a step in the right direction.

So, would this library be suitable for a service which handles a couple hundred connections at once, with each connection on a separate thread (each thread gets its own DB connection)?

Will I even be able to test this with the trial version? It indicates the the IDE is required, which doesn't work for a service.

Dimon · Post by **Dimon** » Fri 11 Apr 2008 13:52

You can use MyDAC for working with services. The MyDAC components provide high performance even when working with a great number of connections.
You can test the Trial Edition of MyDAC with services if you use BCB.