You can add paging to your ODATA feed to limit the data.
Pagination works well, Ive used it before but just couldn’t come to the solution this morning…….Thank you Paul for getting the cobwebs out of my brain.
We have put Mendix 7.23.6 into product and is working well….This was not a 7.23.6 problem….it was a memory and developer problem. :-)