jeudi 9 juillet 2015

improve slite query performance with large tables

I have a big table in my database with thousands of rows and I need to have a quick access with some queries from my android application, let's say t < 0.05 s per query.

Is a good idea to split the big table in many smaller tables and make a switch from the app to decide to which one look at (suppose that the switch is simple in logic and quick to do)?

Aucun commentaire:

Enregistrer un commentaire