Couchbase
  • Why NoSQL?
  • Couchbase Server
  • Download
  • Resources
  • Careers
Home | Forums | Couchbase | Couchbase Server 2.0

Performance Data for secondary Index

1 reply [Last post]
  • Login or register to post comments
Tue, 12/11/2012 - 16:56
makeawish
Offline
Joined: 12/03/2012
Groups: None

I was wondering how scalable the secondary Index is. I have a json doc which has
has as part of its structure a array of tag elements which store userid and name
of the user who was tagged like

Taggs
userid: 1, name: "Frank",
userid: 2, name: "Steve"
taggs

ignore the format its just to give id, so here is my question's

a) how do i access these tagg data ? doc.taggs.userid ?
b) lets assume i build a view what is the expected performance if i have like 10 million docs and
each doc can have between 1 and 1000 tagg's ? And how far will it scale ?
c )my query needs to find all taggs for a given user, would it be better to store all taggs for one user
in a separate doc and keep the docs in sync or is there a way to avoid this and still get a good response
time ?

Any ideas and pointers would be great

Thanks

Top
  • Login or register to post comments
Tue, 12/11/2012 - 22:59
tgrall
Offline
Joined: 09/05/2012
Groups: None

Hello,

Secondary Index is still very fast for the following reason:
- All the data are distributed on all nodes of your cluster, and the index are also distributed (indexes of a document are located at the same place)
- The index is when the document is "added" , see http://www.couchbase.com/docs/couchbase-manual-2.0/couchbase-views-writi...
- When you query the view the query is distributed on all the nodes of the cluster to navigate into the index

You can find some interesting chapter in the documentation:
- Chapter 9. Views and Indexes : http://www.couchbase.com/docs/couchbase-manual-2.0/couchbase-views.html
- Appendix D. Troubleshooting Views : http://www.couchbase.com/docs/couchbase-manual-2.0/couchbase-views-troub...

Regards
Tug

__________________

Tug
@tgrall

Top
  • Login or register to post comments
  • Login or register to post comments
  • Login
  • Register

Company

  • About Us
  • Leadership
  • Customers
  • Partners
  • Contact Us

Product

  • Couchbase Server
  • Couchbase SDKs
  • Use Cases
  • Documentation
  • Forums

Open Source

  • Couchbase Project
  • Couchbase vs. CouchDB

Commercial

  • Subscriptions & Support
  • Training & Services

News

  • Blog
  • Newsletter
  • Press Releases
  • Buzz

Follow Us

    
  • Customer Login
  • Terms of Service
  • Privacy Policy
  • Trademark Policy
  • Site Map

© 2013 COUCHBASE All rights reserved.

Sign in to Couchbase Community

close
  • Create new account
  • Request new password
You are logging into the Forums, Wiki and Issue Tracker