IBDAC and new DevExpress VCL 12.1

[Fabrice]

Hello,

I use IBDAC with all Devexpress components like Tcxgrid and it's work like a charm.
It's work very fine even with full access (read/insert/append/delete) even with complex SQL queries.

But since it version 12.1 there is an interesting things :

The VCL Grid control now supports Server Mode – an ultra-fast, super-efficient data binding mode specially designed to work with large datasets (those with more than 50,000 records). In this mode, the initial page will be displayed immediately regardless of the number of records in the complete data source, and subsequent data will be loaded rapidly when scrolling. Loading records in small sets, and performing data-aware operations on the data server side are the key features of Server Mode that ensure fast access to data, even if the sorting, grouping, filtering, and summary features are used.
The Grid control ships with the Server Mode Table View and two data source components, which allow you to bind the View to a database either via an ADO or dbExpress connection.

This version provides server mode support for MS SQL Server, MySQL, Firebird, InterBase, and Oracle databases. With subsequent releases, we shall add support for other popular databases.

New Components: TdxServerModeADODataSource and TdxServerModeDBXDataSource

Full article here.

Do you have any contact with Devexpress team to
"allow us to bind the View to a database via IBDAC connection.
New Component: TdxServerModeIBDACDataSource" ?


In the other side somebody has already asked a similar question about it in Devexpress support here.


Best regards,
Fabrice

[AndreyZ]

Hello,

All IBDAC dataset components have the FetchAll property. If FetchAll is True, all data is fetched on dataset opening. If FetchAll is False, data is fetched to the client only when it is explicitly requested. As we can see, the "Server Mode" DevExpress feature is intended for the same purpose. We do not develop DevExpress, so we do not know in what ways the "Server Mode" feature differs from our functionality. For more information about this feature and its usage, please contact the DevExpress developers.