MongoDB CRM Database Design Efficiency -


in crm plan able support scale of 100 businesses now, ideally scale size.

the way it's set right now:

each business has 3 sections of data each section has 1000 "entries" each entry has 30 - 50 "data chunks" - each data chunk has id, entry corresponds to, value indicate type of data is, , value it's holding.

100 * 3 * 1000 * 30 = 9000000 pieces of data.

i'll pulling 100 entries @ given time 3000-5000 or data chunks being pulled, once in while many 1000 entries or more @ once.

i have collections businesses, sections, entries, , data chunks.

i'm setting way because business keeping different kinds of data others , sql database doesn't work that.

a sample generation of data might this:

  • find 1 section name (ie business1 has section called section1)
  • find 100 entries section
  • find 30 data pieces each of entries

that'd result in 101 find calls. find call entries , find call data array has 100 or key/value pairs, pull 100 data entries entry id 1 of 100 or key/value pairs.

is scalable database design? there better way should doing it?

putting of related data in separate collections not choice. i'll remind mongodb not have joins design, you're going have hell of time gathering data chunks using entries , sections collections.

because spec pretty vague (i have no idea section, entry, or data chunk represents), it's hard how design this. me, maybe 2 collections - 1 businesses, 1 data chunks in order. have entry , section ids fields on data chunk documents.


Comments

Post a Comment

Popular posts from this blog

javascript - AngularJS custom datepicker directive -

i make custom datepicker directive custom template. but have no idea how start building it... how include date data directive? i appreciate guide or give me advice work on more precisely. it might you! follow below steps html code sample: <label>birth date</label> <input type="text" ng-model="birthdate" date-options="dateoptions" custom-datepicker/> <hr/> <pre>birthdate = {{birthdate}}</pre> <script type="text/ng-template" id="custom-datepicker.html"> <div class="enhanced-datepicker"> <div class="proxied-field-wrap"> <input type="text" ui-date-format="yy-mm-dd" ng-model="ngmodel" ui-date="dateoptions"/> </div> <label> <button class="btn" type="button"><i class="icon-calendar"></i>
Read more

javascript - jQuery date picker - Disable dates after the selection from the first date picker -

<!doctype html> <html lang="en"> <head> <meta charset="utf-8"> <title>jquery ui datepicker - default functionality</title> <link rel="stylesheet" href="//code.jquery.com/ui/1.11.4/themes/smoothness/jquery-ui.css"> <script src="//code.jquery.com/jquery-1.10.2.js"></script> <script src="//code.jquery.com/ui/1.11.4/jquery-ui.js"></script> <link rel="stylesheet" href="/resources/demos/style.css"> <script> $(function () { $("#datepicker1").datepicker(); }); </script> <script> $(function () { $("#datepicker2").datepicker(); }); </script> </head> <body> <p>date 1: <input type="text" id="datepicker1"></p> <p>date 2: <input type="t
Read more