Is it ok to do complex sql queries in mobile? I am using ionic with android (java) and have two databases with Room DB. which contains 9600 entries each. I want to perform some complex queries like get ‘firstname’ which contain char ‘demo’, having age more then ’70’ and and and.
So my questions are:
- does this kinda queries make mobile slow even they async?
- should it better to send request to backend and let it do the calculation (backend have same DB).
- old mobiles with less RAM might not work?? right