High memory usage

[skynetit]

We have a 100 GB collection. Sometimes even for a simple query(query by id filter), it uses lot of memory. Maximum memory I have seen was around 18GB.

[sachabruttin]

How many documents do you retrieve? And how large are they?

[skynetit]

sometimes it is just 1 document but mostly it will be lesser than 20 documents. max document size is 2KB

[Syltty]

same problem here, max items 20, boom 6 GB memory usage after few minutes
When I check network bandwidth usage, download doesn't stop even after results are displayed and memory usage keeps raising.