Devart Forums

Hi;
I'm using Delphi7, SQL 2005, delphi standart ado, Devexpress, sql native client
- How to using SDAC, large dataset (over the 10.000 record and 25 field) for best performance in DevExpress grid only browsing data ?
- can I using smart refreh (adding, deleting, updating record) with large dataset?
- What are the advantages and disadvantages of SDAC over Delphi Standart ADO for accessing SQL Server?
- How to implement forward only recordset? I Need retrieve resultsets with very high performance, usually used in tasks where data require some processing without displaying it within visual DB-controls.

Best Regards

developeradmin wrote:- How to using SDAC, large dataset (over the 10.000 record and 25 field) for best performance in DevExpress grid only browsing data ?

This is described the topic "Performance of obtaining data" in the SDAC help.

developeradmin wrote:- can I using smart refreh (adding, deleting, updating record) with large dataset?

Yes, you can.

developeradmin wrote:- What are the advantages and disadvantages of SDAC over Delphi Standart ADO for accessing SQL Server?

ADO is a universal component set, when SDAC is specialized in SQL Server only. It allows SDAC to use more features of the server and achieve higher performance.

developeradmin wrote:- How to implement forward only recordset? I Need retrieve resultsets with very high performance, usually used in tasks where data require some processing without displaying it within visual DB-controls.

You should set the Unidirectional property of a SDAC component that returns datasets.

Thank you for your answer

Best regards