1

I would like to manually build the dataset used by a TDatasetProvider to return the data to the client.

The SQL request is taking a long time to run as a query and I am trying to speed up things by splitting the logic in code and using a kbmMemtable to hold my data before returning it to the client.

Can I do this:

kbmMemtable -> TDatasetProvider -> TClientDataset

If this can be done, in what event of my TDatasetProvider should I set the data in the memtable ?

Using Delphi XE

Pascal D
  • 258
  • 2
  • 9
  • 1
    "kbmMemtable -> TDatasetProvider -> TClientDataset" Yes. "in what event" It doesn't have to be in an event, just before you open the CDS. But this is a distraction: you would do far better to spend your time optimizing your server-side SQL. – MartynA Sep 05 '17 at 19:18

1 Answers1

0

you could do it in BeforeGetRecords/OnGetData event handler or even elsewhere

Vladimir Ulchenko
  • 463
  • 2
  • 8