Apps Android Database and Performance

[melody10511]

Hey guys, just a quick question. Which will hurt the performance of the application more?

- Database with many tables but less queries.

or

- Database with much less tables but needs more queries during runtime.

Sorry I don't have any background in database handling so I really have no idea. Thanks in advance!

 

[Unforgiven]

I've moved the to the Application Development forum as I think you'll get a better answer here.

 

[jonbonazza]

Short answer: it depends:

More detailed answer:
It depends on many variables such as the number of tables in a database, the number of rows and fields in each table, the content of each cell, etc... It's hard to say really. Your best bet is to try both ways and profile the execution times accordingly.