英文:
App Engine datastore query, to many Indexes
问题
我有一个包含7个输入字段的表单。每个字段都应该查询一个更大和/或更小的值,每个字段都可以为空或非空。由于不等式过滤器只能在一个属性上工作,我想创建一个包含最多20个整数的整数数组属性,并使用一个'Property ='过滤器来查询它,以检查给定数组中是否存在该值。然而,这给我带来了"too many indexed properties"的错误信息。
我有点迷茫,因为我不能在多个属性上使用不等式过滤器,而且列表属性会创建太多的索引。
有人可以指点我正确的方向吗?
英文:
I have a form with 7 input fields. each of these fields should query for a bigger and/or smaller value and every field could be empty or not. As inequality filters work only on one property, I wanted to make an array of int's property, that contains up to 20 integers and query it with a 'Property =' filter to check if the value is present in the given array. However, this gives me the message 'too many indexed properties'.
Im bit lost as i can't use inequality filters on more than one property and list-properties create to many indexes.
Can somebody point me in the right direction?
答案1
得分: 0
你可能想要使用CloudSql或全文搜索来进行这种复杂的查询。特别是,如果你需要为这些查询包括排序,你将面临很多挑战,因为你需要设置显式的多属性索引。然后你将面临一个组合爆炸的问题。
英文:
You probably want to use CloudSql or Full Text Search for this kind of complex querying. In particular, you're going to face a lot of challenges if you need to include ordering for these queries, as you'll need explicit multiproperty indexes set up then. You will then face a combinatorial explosion problem.
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库,让每个人都能够通过互相帮助和分享经验来进步。
评论