使用大表提高slite查询性能-improveslitequeryperformancewithlargetables

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 个解决方案