Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have a project where it is very tempting to use a deeply nested collection of data. But how does that affect performance? Are there any reasons why I should avoid doing this? I'm talking about lists in lists in lists, etc.

share|improve this question

1 Answer 1

Per this StackOverflow thread, it sounds like lists are created by serializing and then deserializing the data.

If you were deeply nesting your documents with list inside of list, that would be a serious performance hit purely from the serialization and deserialization.

If you have a hierarchy like this, I would consider using MySQL, since it's designed for relational data. It would be simple to implement a hierarchy using a relational DBMS compared to CouchDB.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.