#community-help

Does Property Length Matter in Large Collections?

TLDR Nikhil inquired whether the property length matters in large collections. Jason clarified that only the property value length affects index sizes.

Powered by Struct AI
+11
4
6mo
Solved
Join the chat
Mar 23, 2023 (6 months ago)
Nikhil
Photo of md5-07cb09a4ed26d997ee7f71d5f2a017e0
Nikhil
07:25 PM
When we are storing millions of records in a collection where each record has several properties, does the property length matter? For e.g. would it help if the object was {n: 'Richard', ... } instead of {name: 'Richard', ... } ?
Jason
Photo of md5-8813087cccc512313602b6d9f9ece19f
Jason
07:26 PM
No, the properly name length doesn’t matter for the in-memory indices
07:27
Jason
07:27 PM
Only the property value length affects index sizes
Nikhil
Photo of md5-07cb09a4ed26d997ee7f71d5f2a017e0
Nikhil
07:27 PM
Thanks Jason!
+11