Nature of 1500 record limit on DB queries

[RobertJay]

This limit is either a Mongo or Appery (using Mongo for its DB) limit. If I find another DB host with either no or a much higher limit, will Appery be able to support it? Thank you.

[Serhii Kulibaba]

Hello Robert,

1500 it is limitation of Appery.io DB. This restriction doesn't work on your DB. So you can send any amount of DB items, but you should know - app could freez if it should proccess huge data.

[RobertJay]

Thank you Sergiy -- but please clarify. If my Appery service makes a query against a non-Appery DB which has e.g. 5000 records and imposes no limits, all 5000 will be assessed and any number can be returned in results--- and there wouldn't be any Appery limits imposed. Am I correct?

[Yurii Orishchuk]

Hi Robert,

Yes it's correct. 1500 limit is only Appery.io DB limit.

It does not affects Appery.io app.

Note: 1500 items is a lot of data. This data and even more is hard for restricted in calculation resources mobile devices. Thus it's not recommended to use such huge data at once. Better to use page frames(pagination logic) to increase app responsibility(decrease UI delays).

Regards.

[RobertJay]

Thank you Yurii. Yes, as you advised I'm using pagination logic and it works beautifully. Incidentally, my need for 1500 was for the query size; the response was never going to be beyond 100 or so records.

[Evgene Karachevtsev]

Hello Robert,

Sorry, I'm not sure I understand you correctly, could you please clarify do you need further help?

[RobertJay]

Sorry Evgene, no further help needed (except if you know how to grow hair). Thanks, and sorry for not being clear.