FIREDAC Exploration (ii)

and took the time to try Firedac, this would like to find some ways to let FIREDAC take data and dbx like fast, and ultimately failed, the DBX implementation is too fast, 3472 records (110 fields of the table), 0 milliseconds to grab over,

FIREDAC is almost 20 milliseconds faster. But FIREDAC has captured the data tfddatstable, know the number of records, (better than DBX, DBX Dbxreader is not aware of the number of records)

If you just let Fdcommand execute SQL and not Feach to tfddatstable, then it is 0 milliseconds (but not the data).

Besides

Fdmemtable1.attachtable (fddatstable, nil);
Fdmemtable1.open;

If the data is displayed in DBGrid, the FIREDAC is very fast, compared with Tdbxclientdatasetreader.copyreadertoclientdataset (Dbxreader, ClientDataSet1);

It should be said that with the data control, FIREDAC is very good.

In addition, try to use FIREDAC in Datasnap, although you can return n data sets with Tfdjsondatasets, but the speed feeling is not very good, need to be optimized. While using Dbxreader speed is very fast, it is still a bit inconvenient to return multiple result sets. You should have an advantage. If it is customary to return the entity class to the client in DATASANP, or if there is a DBX that has the advantage of speed, if the custom returns TDATASET, the client uses the DB control, which is more convenient with FIREDAC. Datasnap's core is based on the DBX framework, and the personal feel of the DBX framework is well designed, and for quite a long time, datasnap is not going to change anything unless EMB launches a new framework. In the present situation, EMB should not spend energy and time to launch new products. However, FIREDAC is also EMB the data Access layer component of the main push, and the better fit between datasnap is really a bit of a headache.

However, it is not really cool if EMB always let the program develop the program in the way that it handles the delta. Early ADO can also filter "add" and delete "Change" records, but no one in. NET is doing this, or it's like a Java framework.

Besides Datasnap can also pass the packing class, why not go further!?

FIREDAC Exploration (ii)