[SERVER-826] Allow indexing of several arrays Created: 24/Mar/10  Updated: 31/Oct/23

Status: Backlog
Project: Core Server
Component/s: Index Maintenance
Affects Version/s: None
Fix Version/s: None

Type: New Feature Priority: Major - P3
Reporter: Karoly Negyesi Assignee: Backlog - Query Optimization
Resolution: Unresolved Votes: 10
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Depends
Duplicate
is duplicated by SERVER-53574 Support for index on multiple array f... Closed
Related
is related to SERVER-16704 2dsphere index appears to allow index... Closed
Assigned Teams:
Query Optimization
Participants:

 Description   

While I understand the N^2 complexity of parallel arrays maybe something could be done? Like, allow a limitation of just how how many items will be indexed from an array? While in theory an array can be any number of element in reality we might know that a certain array will be small.



 Comments   
Comment by Jean-Samuel Girard [ 31/Oct/23 ]

This is a huge problem for our use case.

We have a lot of fields with dynamic typing we don't know in advance if it's going to be an array or not.

Since our field can become Arrays at any moment, how are we supposed to sort and index our fields ? We can't index them because as soon as one of our documents has two or more fields that become Arrays it would fail.

At least give us an option to bypass this...

Comment by Tim Rayburn [ 08/Feb/12 ]

This is a major impact to a project I'm working on right now, we use arrays in many places, and our Web UI suffers from speed issues due to this limitation.

Comment by Remon van Vliet [ 01/Jul/11 ]

I do not think there should be any limitation put in place on grounds of "idiot proofing". There are quite a few use cases where an index on multiple small arrays makes sense.

Comment by Karoly Negyesi [ 24/Mar/10 ]

Actually, due to uniformity, Drupal stores 1-element arrays often. Maybe just make an exception for 1-element arrays? That would be tremendous help.

Generated at Thu Feb 08 02:55:16 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.