[Solved] Filter dataset, memory growing up?

[lainz]

I have a dataset (Offers: TBufDataset;) where I have stored all "discounts & offers".

Offers.Filter := 'type = 0'
Offers.Filtered := True;

We have 9 kind of offers. The dataset is Filtered to look for the kind of offer, say offer type 0, offer type 1, and so on.

That procedure grows a lot the memory usage of the program every time is called. If I remove the filter lines, saying there are no offers, there is no leak.

It can be that filtering can cause memory grow, but no memory leak is found at the end of the program?

[valdir.marcos]

I have a dataset (Offers: TBufDataset;) where I have stored all "discounts & offers".

Code: Pascal  [Select][+][-]

1. Offers.Filter   := 'type = 0'
2. Offers.Filtered := True;

We have 9 kind of offers. The dataset is Filtered to look for the kind of offer, say offer type 0, offer type 1, and so on.
That procedure grows a lot the memory usage of the program every time is called. If I remove the filter lines, saying there are no offers, there is no leak.
It can be that filtering can cause memory grow, but no memory leak is found at the end of the program?

Could you provide a small sample project?

[lainz]

Sure, here is a test project that shows the memory growing bug.

On my machine is about 100 kb per second the quantity of memory that grows and then never comes back (looking at the task manager on Windows 10).

Edit: to see memory growing faster, increase the number of records generated to 10000. But take into account that maybe you need to kill the application then.

[lainz]

Reported in bugtracker
https://bugs.freepascal.org/view.php?id=35756

[lainz]

Well it was solved as 'Memory Fragmentation' or 'blame the DBGrid'. With no DBGrid it still increases memory, so it must be the first choice.

I close this since no one will fix it, because "there are no leaks", but memory increases anyways, so better not use filter like I'm doing in the example.

[lainz]

Reopen.

Thanks to BrunoK for opening a new issue with a fix
https://bugs.freepascal.org/view.php?id=35759