[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: |
|
||||||||||||||||||||
| 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. |