Performance optimizations in production

added by DotNetKicks
2/28/2022 2:48:34 PM

175 Views

Date range queries can be quite expensive for RavenDB. Consider the following query: from index 'Users/Search' where search(DisplayName, "Oren") and CreationDate between "2008-10-13T07:18:01.623" and "2018-10-13T07:18:01.623" include timings() The root issue is that we have a compound query here, we use full text search on the left but then need to match it on the right.


0 comments