I was absolutely shocked by the poor performance of the service.
In my case I prototype some simple CRUD queries with NodeJS ,within the same datacenter region.
Insert took well over a second to complete and reading a simple document with one field took also half a second.
I was also unable to make « join » between document because how complex their query language is and their support basically encouraged me not to use « join » but to use « aggregate » like mongo ... Why offer this feature if I can’t use it ?
Has it changed since then ? It seems very clear for me that Fauna is entirely focused on Enterprises customers ( after all this is where the money is ) the cloud version seem to be just a gimmick.