couchdb-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Volker Mische <volker.mis...@gmail.com>
Subject Re: GeoCouch performance: any suggestion to improve it ?
Date Tue, 16 Apr 2013 09:35:20 GMT
Hi Luca,

On 04/16/2013 12:57 AM, Luca Morandini wrote:
> Folks,
> 
> I built a test rig to assess the performance, geo-spatial-wise, of
> PostgreSQL vs CouchDB, and I have found out that -on average- CouchDB
> takes double the time of PostgreSQL when completing a spatial query.

That's cool, I've expected GeoCouch to be even slower.

> I have tried different ways of defining the view and converting the
> response into GeoJSON; the best results happened when putting the
> geometry on the key and using a list function to generate GeoJSON (which
> entails stringifying JSON in hte list function).
> 
> Moreover, I had the impression that the transfer of data from views to
> list functions takes quite a bit of time, since performance worsened
> when I tried to put geometries in values as string in order to avoid
> stringifying them in the list function; this, of course, caused doubling
> the amount of data in the view (geometries were both in the key and -as
> strings- in the value).
> 
> Any suggestions to improve performance ?

In case your Apache CouchDB is under your control and not hosted
somewhere, you can try to write your list function in Erlang.

Cheers,
  Volker



Mime
View raw message