Hello, We have a use-case where comparing dates require precision down to the second. We created a a predicate date as a type datetime with an index. As we build-up the query we need, it gets progressively slower. We’re pretty certain it has to do with the DateTime Hourly index we have on the fi…

Date Comparisons - Speed differences with data at scale

matthewmcneely (Matthew McNeely) April 12, 2025, 4:35pm 3

IMO, this is the way. I don’t have specifics from past implementations, but I do know this approach was a no brainer for a large graph from which queries were heavily “time-based”.

Topic		Replies	Views
Filter by DateTime Users	2	710	April 16, 2018
Don't understand DateTime search index in GraphQL GraphQL graphql , kind:question , help-wanted , datetime	7	1231	September 7, 2020
Bug in @filter() for day indexed edge Dgraph kind:bug	13	554	March 19, 2020
Bug in date filtering Dgraph kind:bug	7	591	June 10, 2020
What's the benefit to using a dateTime @index(hour) vs a string @index(exact) Dgraph	1	828	December 6, 2018

Date Comparisons - Speed differences with data at scale

Related topics