[SERVER-25669] TTL Index on Embedded documents(sub documents) Created: 17/Aug/16  Updated: 06/Dec/22  Resolved: 19/Sep/16

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

Type: New Feature Priority: Major - P3
Reporter: pravin dwiwedi Assignee: Backlog - Storage Execution Team
Resolution: Duplicate Votes: 3
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Duplicate
duplicates SERVER-10286 TTL on subdocument arrays Closed
Assigned Teams:
Storage Execution
Participants:

 Description   

Right now TTL index removes the whole document.
It would be very helpful if we can create TTL index on a field in sub documents/embedded documents too so that only those documents would be removed rather than removing whole document. In absence of this feature we are right now using scheduled update statements which creates pain to monitor the crontab jobs.



 Comments   
Comment by Ian Whalen (Inactive) [ 19/Sep/16 ]

Hi Pravin, thanks for filing this feature request. Looks like this is a duplicate of SERVER-10286 - please add yourself as a watcher there for updates and please vote to indicate your interest.

Comment by Ramon Fernandez Marina [ 18/Aug/16 ]

Thanks for opening this ticket 2k.pravin@gmail.com; I'm sending this to the team for evaluation, but note that a feature like this one may require a completely new index type and functionality, so I don't think it's a minor improvement.

It is also unclear to me how the TTL monitor may find documents that contain the subdocuments you want to delete, so my first inclination is to think that you're "embedding data too much" and the easiest way forward would be a schema change – but let's see what others think.

Generated at Thu Feb 08 04:09:50 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.