MSSQL dbexpress driver vs ADO performance. Some help?

epachsoft · Post by **epachsoft** » Mon 26 Jun 2006 15:28

Hi guys,

Simple and quick question, based on your own experiences (users) and CoreLab testings (any help there guys

), do i get a better performance out of using dbexpress with the crlab drivers than using ADO?

We have this big Component services (MTS) deployment using ADO, but we love to get any piece of performance advantage we can, we are thinking about moving everything to dbexpress, but, we want to hear first if someone has positive experiences with the change.

Just in case the question comes, we are not looking to move yet to another database (aka Oracle), it is a nice thing to have in the future, but, future multiple database capability is not on our scope, so that as a plus in our decision doesnt count.

Thanks.

Jackson · Post by **Jackson** » Tue 27 Jun 2006 09:33

DbxSda performs much faster access to data than rivals including ADO and standard dbExpress driver for MS SQL Server. We regularly carry out performance tests to ensure that our products are better than rival products. But I advise you to use SDAC as dbExpress technology has many restrictions, flaws and errors.
Moreover, SDAC gives you much more features and improves performance. It contains migration wizard which simplifies conversion of already existent projects from ADO/BDE to SDAC.
You can download SDAC trial versions here http://crlab.com/sdac/download.html

epachsoft · Post by **epachsoft** » Tue 27 Jun 2006 18:45

Thank you for replying.

Browsing around your website i found a nice performance comparative test for the ODAC product between the different providers, do you guys have something like that for dbexpress or SDAC?

Now, my problem is that if i move to SDAC and in the future we decide to support Oracle then i will have to go through the migration process again to support ODAC.

If i move to dbexpress using your drivers, which based on your comments give a better performance than ADO, then when i moved to Oracle it will be just a matter of changing drivers and tweaking queries.

In summary thanks for the feedback, it gets me one step closer to justify the change to dbexpress and crlab drivers.

Jackson · Post by **Jackson** » Thu 29 Jun 2006 11:23

If you have in plans migration to Oracle then dbExpress is more preferable for you.
SDAC contains performance demo. You can download trial version and try it yourself.