I have a sqlite database with multiple tables pointing to eachother.
Now I was wondering what would be better to use:
1. A join query - this would require a SQLiteQueryBuilder and some projection mapping.
2. multiple queries - this would be easier because I don't have to worry about projection too much.
Would it performance-wise be better to use option 1 or doesn't it make much difference?
Now I was wondering what would be better to use:
1. A join query - this would require a SQLiteQueryBuilder and some projection mapping.
2. multiple queries - this would be easier because I don't have to worry about projection too much.
Would it performance-wise be better to use option 1 or doesn't it make much difference?