Thank you for coming back to this thread to share your experience, much appreciated!

I did not realize RethinkDB lacks a query planner/optimizer. That is a huge downside. The docs didn't seem to make much effort to point out this limitation.