>Which would suggest that it might be a bit slow to do many round-trips for each query.
I was curious and found some information through a search (key point italicized) [1]: "On the performance aspect, with a real world use case of 1GB index, just 150KB of data must be transferred on average over three requests to fetch the results back. In full text search terms, 250MB of data can be queried in around 500msec which even though slow, may not be prohibitively slow for some use cases. Insert queries also may take around the same time. The number of requests needed to fetch the query results grows logarithmically with the data size."
[1]: http://www.infoq.com/news/2015/04/Encrypt-Database-CryptDB-Z...
>I'm guessing there could be some specific use-cases where this is not so relevant?
They claim the performance degradation is not much, but that would become worse as the number of clients grows. The clients also would need to have a relatively decent amount of RAM and CPU power to handle this.
Related: CryptDB from MIT - http://css.csail.mit.edu/cryptdb/