Watch, Follow, &
Connect with Us

For forums, blogs and more please visit our
Developer Tools Community.


Welcome, Guest
Guest Settings
Help

Thread: TFDMemTable - [Slow Reading, Slow Writing, Big Binary].



Permlink Replies: 0
wesley bobato

Posts: 19
Registered: 3/17/10
TFDMemTable - [Slow Reading, Slow Writing, Big Binary].
Click to report abuse...   Click to reply to this thread Reply
  Posted: Dec 6, 2016 7:43 AM
Hello Support.

I found some "Failures" with TFDMemTable.

1 - When using FDMemTable1.BeginBatch and FDMemTable1.EndBatch;
    RecordCount Always Returns 0 after Inserting Multiple Records into Table.

2 - TFDMemTable is very slow to stop inserting and loading binary files compared to TClientDataSet.
    
TClientDataSet
* Append ..: 00: 00: 10.330
* Load Binary File ..: 00: 00: 00.893
* Size File ..: 52,9 MB (55,568,957 bytes)

TFDmemTable
* Append ..: 00: 00: 15.620
* Load Binary File ..: 00: 00: 08.070
* Size File ..: 102 MB (107,869,971 bytes)

3 - I migrated my project with TClientDataSet and TxQuery and found that Firedac does not support
    Some Primitive Data Types such as TBytesField and TVarBytesField with Local SQL.

    TFDConnection, TFDQuery, TFDLocalSQL, does not support TBytesField or TVarBytesField.
     * 'Select sum (c1) from FDMemTable3';
     * 'Select min (c1) from FDMemTable3';
     * 'Select max (c1) from FDMemTable3';

     * 'Select count (c1 [0]) from FDMemTable3';
     * 'Select count (c1 [1]) from FDMemTable3';
     * 'Select count (c1 [2]) from FDMemTable3';
     * 'Select count (c1 [3]) from FDMemTable3';

     * 'Select c1 from FDMemTable3 where c1 [0] = 2';
     * 'Select c1 from FDMemTable3 where c1 [1] = 3';
     * 'Select c1 from FDMemTable3 where c1 [2] = 4';
     * 'Select c1 from FDMemTable3 where c1 [3] = 5';

Thank you very much for your attention. It will be that in the next version of Delphi Firedac will work the same as the TClientDataset and
SQL Local Ira Support TBytesField and TVarBytesField Types as TxQuery?

Kind regards.

Links Here.
https://www.dropbox.com/s/co4eu9qsu7yx6ns/TFDMemTable.zip?dl=0
Legend
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02