Devart Forums

Hi CoreLab team.

I have a feature request for SQL Server Access components :

Please add a new component to the package which allows simple data fetching via SELECT-statements but which does NOT descend from TDataset. If somebody (like me ) wanted to fetch data in code it would be a lot faster because the were no TDataset/TMemDataset overhead for each query.

Please check out the following web site to see how another company did this for MySQL:
http://microolap.com/products/connectivity/mysqldac/
-> see component "TmySQLDirectQuery"

I think such a component makes a lot of sense since a lot of data fetching is used in code and not on the UI. Especially for stuff like DB-persistent objects it would be awesome!!

Thanks and keep up the great work!

Marco

We do not think that such component will increase performance of SDAC more than 20%. SDAC does not take much time to handle data. As our performance tests show, most time is taken by the server and network.
So, we do not think that there are enough reasons to add the new component to SDAC.