Hi all! My team is laboring between the decision t...
# community-help
h
Hi all! My team is laboring between the decision to fully commit to zero-downtime schema change operations resulting in needing to fully reindex the new collection and then point the alias to it, and allowing acceptable write-blocking schema changes. Is there information somewhere about "how long" an operation like "adding a new field" or "deleting a field" against a collection with data in it would take, ie how long write operations would be blocked for? I think this is a crux that will help us decide. Thank you!
1
j
There's unfortunately no one answer to that question, because it completely depends on the shape of your data, and the number of documents in your collection
So you would have to test it against your own dataset to determine how long it takes
h
Is there no rough "napkin" math approach I could take? I'm even look for ridiculous lower/upper bounds.
j
I've seen some changes on collections with a 10s of thousands of docs take about 30s and on the other hand, I've seen collections with millions of docs and several fields take a few hours
h
Excellent 🙏 Thank you!
This is great information for us, as I assume we're likely int he 10s of thousands and knowing an upwards bound of 30s is probably unaccpetable for us, so this is super helpful and will guide us more towards zero-downtime via using collection alias. Again, thank you VERY much!!
👍 1
b
Collection aliases work really smoothly for us, 1MM docs with a quite diverse and large collection schema, and TS staying very responsive throughout the indexing of the new collection/alias switch/cleanup of old collection.
👍 2
h
Awesome, ty!!!