queries are too long -- about 30 minutes

[Dima G <dm...@yahoo.com>]

Hello,
I have a db, about 7 500 documents, each document contains couple long arrays of prices. Pure size of this data is about 300-400Kb. db size in couchdb is 3.3 Gb. When I am doing the simple queiry like 

function(doc) {
    emit(doc.symbol, null);
}

I am getting result only after 30 minutes and more! If I do "get" request from ruby with couchrest gem, then it is instantaneous.
What I am doing wrong?
What is the best way to store such long data arrays?

Versions:
Futon on Apache CouchDB 0.8.1-incubating
processor -- intel 4 core

Please, help



      

Re: queries are too long -- about 30 minutes

[Chris Anderson <jc...@apache.org>]

On Wed, Nov 12, 2008 at 11:38 PM, Dima G <dm...@yahoo.com> wrote:
> I am getting result only after 30 minutes and more! If I do "get" request from ruby with couchrest gem, then it is instantaneous.

Are you using temp views or views in design docs?

The initial view computation will take some time (and for temp views
this will occur on every query). With design docs, the follow-on
requests should be basically instantaneous. That said, large view keys
can slow things down. Is your doc.symbol 300Kb? If so, you should
think about building a view with smaller keys...

If none of this helps with the speed, also note that some old versions
of erlang are known to be much slower than the current releases.

-- 
Chris Anderson
http://jchris.mfdz.com