Setup: D7, MemTable 5.5, dbExpress, Oracle.
I have a table with about 10,000 records reasonably column density.
It takes just under a second to do this
SQLQueryPlus1.Open;
while not(SQLQueryPlus1.Eof) do SQLQueryPlus1.Next;
basically retrieving all records to the client.
Then a do this
kbmMemTable1.EmptyTable;
kbmMemTable1.LoadFromDataSet(SQLQueryPlus1,
[mtcpoStructure,mtcpoProperties]);
This takes about 4.5 seconds. Does this seem right (slow)?