What is the performance comparison between Queryable encryption and CSFLE? if I’m looking to encrypt strings of size in KBs stored in mongo db cluster?
Hello. I’m the Product Manager responsible for QE and CSFLE. Performance is always a super nuanced topic, but in short, both QE and CSFLE offer good performance (or we wouldn’t implement it). QE provides the benefit of expressive queries with a good and well-studied security profile. In your case, it sounds like you’re encrypting fields of long strings (on the order of KB). QE doesn’t have substring search on encrypted data yet (we’re working on that now), so CSFLE with randomized encryption would do just fine. If you have other fields in the collection that you want to be able to search on (shorter strings, numeric, etc.) you may want to choose QE for the document instead and just specify the long strings to encrypted but don’t specify a query type so the encrypted indexes aren’t generated. I hope this helps.
New & Unread Topics
Topic | Replies | Views | Activity |
---|---|---|---|
Regarding MonogoDB support for serializable isolation level | 0 | 466 | May 2024 |
Darshan Hiranandani : How should I plan the implementation of an ExpressionSearchDefinition in my project? | 0 | 113 | Aug 2024 |
Darshan Hiranandani : How can I retrieve information on documents that were inserted within the last 2 or 3 days on a standalone server? | 1 | 158 | Aug 2024 |
Error – Option “explain” cannot be used on an aggregate call with writeConcern | 3 | 372 | Sep 2024 |
Extra space occupied by Indexes | 4 | 73 | Feb 10 |