Suggestion: Fast component for data fetching

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Posts: 3
Joined: Wed 23 May 2007 08:25

Suggestion: Fast component for data fetching

Post by MarcoTheFirst » Fri 15 Jun 2007 15:36

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:
-> 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!


Posts: 2098
Joined: Tue 14 Feb 2006 10:14

Post by Antaeus » Tue 19 Jun 2007 12:25

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.

Post Reply