http://ayende.comAyende @ RahienCopyright (C) Ayende Rahien 2004 - 2021 (c) 202660Nuno: Lucene can do range searches, see [lucene.apache.org/.../queryparsersyntax.html](http://lucene.apache.org/java/2_4_0/queryparsersyntax.html#Range%20Searches). I don't know how it does in internally though. RavenDB then handles this for you when you index a filed that is numeric, see [http://ravendb.net/documentation/how-indexes-work](http://ravendb.net/documentation/how-indexes-work). http://ayende.com/4611/entity-table#comment7http://ayende.com/4611/entity-table#comment7Fri, 15 Oct 2010 16:27:45 GMTHi, I understand that RavenDB uses Lucene for indexing. There are situations where we would like to search by field, say a range of dates with another value: "SELECT * FROM POSTS WHERE PostDate >= @StartDate AND PostDate >= @EndDate AND BloggerID = "nbplopes"; How does Lucene perform with this? Does it perform a full scan or applies a smarter algorithm? If it does not perform that well, can we use another kind of DB for index tables? Say MYSQL? Nuno http://ayende.com/4611/entity-table#comment6http://ayende.com/4611/entity-table#comment6Fri, 15 Oct 2010 15:49:56 GMTElaborating on what was easier and/or more difficult would make for an interesting series or posts. http://ayende.com/4611/entity-table#comment5http://ayende.com/4611/entity-table#comment5Mon, 30 Aug 2010 12:19:01 GMTP. Chen defined 'entity' decades ago. It still stands, as it has nothing to do with _implementation_ aspects (table, document, class etc.), but with what you recognize in the problem domain. http://ayende.com/4611/entity-table#comment4http://ayende.com/4611/entity-table#comment4Mon, 30 Aug 2010 12:17:33 GMTYeah that's pretty much why we should always write do our domain models-first so we know what compromises we are making in order to fit in within a RDBMS. http://ayende.com/4611/entity-table#comment3http://ayende.com/4611/entity-table#comment3Mon, 30 Aug 2010 11:58:05 GMT"a whole range of issues just went away" but which issues did you get back for it? ;) For one, I can imagine that the referential integrity implemented (forced) by the sql databases is felt missing in document databases. What (other) problems (in relation to Raven) did you encounter with this project, and how did you fix them? // Ryan http://ayende.com/4611/entity-table#comment2http://ayende.com/4611/entity-table#comment2Mon, 30 Aug 2010 11:45:21 GMTEvery DDD guy would probably say, that the assumption Entity == Table is false in the majority of Domains ;-) http://ayende.com/4611/entity-table#comment1http://ayende.com/4611/entity-table#comment1Mon, 30 Aug 2010 09:49:16 GMT