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.
我的数据库中有一个包含数千行的大表,我需要快速访问我的android应用程序中的一些查询,假设每个查询t <0.05 s。
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)?
将大表拆分到许多较小的表中是一个好主意,并从应用程序切换到决定哪一个(假设交换机逻辑简单,快速做)?
1 个解决方案
#1
0
you can use FTS
你可以使用FTS
http://developer.android.com/training/search/search.html How to use FTS3 in SQLite
http://developer.android.com/training/search/search.html如何在SQLite中使用FTS3
#1
0
you can use FTS
你可以使用FTS
http://developer.android.com/training/search/search.html How to use FTS3 in SQLite
http://developer.android.com/training/search/search.html如何在SQLite中使用FTS3