Ayende Rahien

You may want to take a look here: https://ayende.com/blog/152833/orders-search-in-ravendb 80 properties isn't a problem from RavenDB perspective, it is a problem from UX perspective.

Can you try changing this `(true and not exists(result.DebtorLocations))` to `where result.HasDebtorLocations = false` Where the index define this as `HasDebotLocations = result.DebtorLocations.Count > 0`

That said, I would love to get the query plan (`include timing()`) and the profiler output (such as DotTrace) if you have them

We have a local reproduction. Looking into this. That said, what is the speed of this query: ``` from index 'PreOrderAll' as result where result.Date = "2024-07-09T00:00:00.0000000Z" and not exists(result.DebtorLocations)...

Basically, we have a couple of missed optimizations here. `true or` is still basically *all* docs, did you intend that? Not `or` vs `and`. `true and` may still do some...

We created the following issues: https://issues.hibernatingrhinos.com/issue/RavenDB-22602/Corax-Optimize-true-or-queries https://issues.hibernatingrhinos.com/issue/RavenDB-22603/Corax-Optimize-true-and-queries

Are you running two instances of your application, each with a RavenDB instance? If there is just one process, can you share you initialization code? It should create exactly one...

> [@ayende](https://github.com/ayende) Its a windows service. Under normal operation there should only be a single process instance. In this case 100% sure the task manager was not showing multiple instances....

> > There _is_ a file lock, mind - that is why you are seeing the error. > > Yes, I understand, but its the log file. You're using that...

For _large_ databases, especially on slow disks, we may need to run for a _while_ to complete recovery. In this scenario, you have: * Your service starts, and runs the...