I was wondering is having multiple document types in a single bucket is still the desired bucket design when using N1QL. It seem that creating a different bucket per docType would be faster that keeping all the documents in one bucket. The documentation states KeySpaces are analogous to buckets.
If I had 10,000 documents which was set up like this:
5,000 docTypes dogs
2,500 docTypes cats
2,500 docTypes birds
Create an index on docType
select * from BUCKET_PETS where docType = ‘dogs’;
Is there a benefit to separate the different doctype in their own buckets?
So in this example one for dogs,cats, and birds.