Hello, I was wondering what would be the best FieldType for storing date with a millisecond precision that would allow me to sort and run range queries against this field. We would like to achieve the best query performance, minimal heap - fieldcache - requirements, good indexing throughput and minimal index size in that order.
To give you some background, we have a production system that runs in a multicore set up, each core with a maximum index size of 6G each, and, the search and indexing operations occur against the same cores. We store the date with a minutely precision(format yymmddhhmm), and, we use TrieIntField with a precisionStep=1. This works well, however, as a next step, we want to store the date with a millisecond precision with minimal architectural changes. We could probably use TrieLongField, however, as we understand, this doubles the heap requirements for fieldcache. Was wondering if there is a clever way of achieving this without adding to the heap. Appreciate your input. Thanks, -Jibo
