migrating from NexusDB
I am migrating my app from NexusDB to postgres and postgresql DAC. I running into performance problems and memory issues. My app lets users navigate and edit datasets using a DBnavigator. These tables (or queries) can be quite large. When I open a dataset and navigate to last, all the records are read into memory, resulting in a "out of memory" message. Is there a way around this? I want to be able to let my users navigate to the first or last record, but I don't need to cache ALL the records, only the current one. If I use a unidirectional dataset, I cannot edit the dataset.
So I want to limit the amount of cached records to 1 (or a limited set) like the unidirectional datasets, but have the freedom to navigate back and forth, and edit the dataset. Is this possible? Do the Devart DAC components work the same as Firedac in this respect?