On Sat, Dec 20, 2008 at 11:32 PM, Antony Blakey <[email protected]> wrote: > > On 21/12/2008, at 2:54 PM, Paul Davis wrote: > >> View update times should be linear in terms of *new* records. > > Well, with a factor to deal with the reduction, which isn't O(n). >
Kinda. I'm pretty sure they're still O(N), just not as pre calculated as one might expect. >> >> >> On Sat, Dec 20, 2008 at 11:20 PM, paul jobs <[email protected]> wrote: >>> >>> it is a permanent viewbut every repeat request takes time as new users >>> are >>> constantly added to the db >>> >>> On Sat, Dec 20, 2008 at 8:16 PM, Paul Davis >>> <[email protected]>wrote: >>> >>>> If it's a temp view, no. >>>> >>>> If it's a permanent view, no. But *repeated* requests should be nearly >>>> instantaneous. >>>> >>>> That is all. >>>> >>>> On Sat, Dec 20, 2008 at 11:04 PM, paul jobs <[email protected]> wrote: >>>>> >>>>> map: >>>>> function(doc) { emit(doc.zodiac, 1) } >>>>> reduce: >>>>> function(keys, values) { return sum(values)} >>>>> >>>>> >>>>> Key >>>>> Value *null*149877*"aquarius"*98747*"aries"*103072*"cancer"*104318* >>>>> "capricorn"*97605*"gemini"*103708*"leo"*107982*"libra"*104955*"pisces"* >>>>> 101741*"sagittarius"*92975 >>>>> >>>>> total number of records ~2 million >>>>> >>>>> this query takes quite some time to run >>>>> is there any way to make this query run faster >>>>> >>>>> thanks >>>>> >>>> >>> > > Antony Blakey > -------------------------- > CTO, Linkuistics Pty Ltd > Ph: 0438 840 787 > > Only two things are infinite, the universe and human stupidity, and I'm not > sure about the former. > -- Albert Einstein > >
