Data Modeling & Indexing

Showing 27

Compound clustered index

Now it is possible to create a clustered index for only one field. Since documents can be arranged in ascending order of multiple fields, I see no reason to disallow a clustered index from being a compound. Expected syntax: ``` create_collection(...

Guest almost 3 years ago in Data Modeling & Indexing 0 Submitted

3 VOTE

bloom filter index

https://www.percona.com/blog/2019/06/14/bloom-indexes-in-postgresql/ I think having an option to use bloom filter indexes could provide for better performance when compared to compound indexes and eliminate the need for having multiple indexes. I...

Guest about 3 years ago in Data Modeling & Indexing 0 Submitted

3 VOTE

Support compound TTL index

Right now you can only do a single field TTL index. I would like a put a TTL on a compound index.

Guest about 3 years ago in Data Modeling & Indexing 1 Submitted

2 VOTE

Tool for score data model

It would be great to have a tool which can scores a data model from a specific database. I mean, I could allows this tool to scan a database model and score this data model based on best practices, patterns and anti patterns. It could also generat...

Guest about 2 years ago in Data Modeling & Indexing 0 Submitted

4 VOTE

Allow multiple text indexes per collection

MongoDb only allow one text index by collection, in contrast of other index types. This is a limitation that makes it difficult to develop projects with search functionality, for example, if you want to add a text search for advanced users on all...

Guest about 5 years ago in Data Modeling & Indexing 1 Submitted

2 VOTE

Clustered Collection TTL on _id should support ObjectId.

Clustered Collections have the ability to expire on the _id field, this would be really helpful if it could use the timestamp portion of the ObjectId.

Guest almost 3 years ago in Data Modeling & Indexing 0 Submitted

2 VOTE

Support Two Array Fields in Compound Indexes

Hi, I've come across a lot of use cases where the business logic has demanded unique constraints on 1-2 fields that have been modeled as arrays on documents. The cases that only contain a single array field is already taken care of using unique i...

Guest almost 3 years ago in Data Modeling & Indexing 0 Submitted

1 VOTE

TTL index activity statistics

Dear all, Presently, there is no visibility or tracking of TTL index activity: no data available to the user to see how much data and how often has been deleted. I suggest having a separate “dictionary” collection with statistics for all TTL inde...

Guest over 1 year ago in Data Modeling & Indexing 0 Submitted

2 VOTE

Add numerically-ordered index feature which forces a field to maintain ordering

I would like MongoDB to add better support for ordered lists across documents in a collection. This feature would allow the user to designate a field such as "position", and the DB would ensure the values of that field across documents remain in a...

Guest about 3 years ago in Data Modeling & Indexing 0 Submitted

2 VOTE

Make it clear an index not on present on all shards

We recently had an issue where an index did not get created on all shards. When we ran getIndexes() on mongos it reported the index was present. So we dropped another redundant index thinking all would be well - it was not. We had serious performa...

Guest over 3 years ago in Data Modeling & Indexing 0 Submitted

Please enter your email address

FILTER BY CATEGORY