timeout on view query

[YIXIAO SHEN <yi...@gmail.com>]

Hi,

I am using BigCouch and running a 6-node cluster of BigCouch. I have a
table with 1 million documents, partitioned into 6 shards, each document
has 100 fields: field0 - field99. And each field is 100 Byte. I have a
query which only needs to get field0, so I added a view on the table:

{
   "scan": {
       "map": "function(doc) {\n   emit(doc._id,\n  {\n    field1:
doc.field1\n  });\n}"
   }
}

I tested ths view with smaller table size (1000 documents) and it worked
fine, first query takes several seconds, and later queries are really fast.
But when I create the same view and query this view on my 1 million record
table, it gives the following error:

{"error":"timeout","reason":null}

can anyone give me a hint how this could be solved?

Thanks

Re: timeout on view query

[Robert Dionne <di...@dionne-associates.com>]

Hi,

  Is there anything in the logs? How is your cluster configured? Q=6 and N=?   Anyway you might want to open an issue[1] in the BigCouch project so you can reach a wider audience.

Best,

Bob


[1] https://github.com/cloudant/bigcouch/issues?sort=created&direction=desc&state=open




On Nov 28, 2011, at 3:28 PM, YIXIAO SHEN wrote:

> Hi,
> 
> I am using BigCouch and running a 6-node cluster of BigCouch. I have a
> table with 1 million documents, partitioned into 6 shards, each document
> has 100 fields: field0 - field99. And each field is 100 Byte. I have a
> query which only needs to get field0, so I added a view on the table:
> 
> {
>   "scan": {
>       "map": "function(doc) {\n   emit(doc._id,\n  {\n    field1:
> doc.field1\n  });\n}"
>   }
> }
> 
> I tested ths view with smaller table size (1000 documents) and it worked
> fine, first query takes several seconds, and later queries are really fast.
> But when I create the same view and query this view on my 1 million record
> table, it gives the following error:
> 
> {"error":"timeout","reason":null}
> 
> can anyone give me a hint how this could be solved?
> 
> Thanks