I have a very specific use case. I need to know the performance of four different implementation approaches and get recommendation on the best one for the given case study.
On which Stack Exchange site can I ask this question? Is it off-topic for Stack Overflow?
I am going to make an Android app, I care the most about speed. The app needs a database. There are a few entities. The problem is the many-to-many tables. there are A LOT of m-m relationships between entities. Each table will hold tons of rows, think +10K
Now how to approach this?
- local SQLite: the problem is the join statements. writing them is going to be a pain. Also, should I use an ORM? or will the join tables make it harder?
- Firebase: is it fast enough? can it handle these relationships to begin with? using it will assure constant backup which is something I want
- custom REST API: add all the heavy lifting in the remote server, problem is it will need an active internet connection. Plus I think the many calls to the server (the app is heavy in POST request/save to db) is going to slow it down. Most importantly, it is an overkill
SQLite seems to be the fastest. but it doesn't have the same power as MySQL or PostgreSQL (custom API route) for example.
So, where do I ask this question? And how can I edit it to suit a certain Stack Exchange site?