stringified json vs json object memory usage in mongodb -

-

just seeing if has experience following. if want store nested json object may have anywhere 10 500 key:string pairs, better store nested json object string or keep object? memory penalty keeping value json object rather string?

you can check size of document object.bsonsize() in mongoshell

for example:

> object.bsonsize({}) 5 > object.bsonsize({a:''}) 13 > object.bsonsize({a:'',b:''}) 21 > object.bsonsize({a:'',b:'',c:''}) 29  > object.bsonsize({a:{a:'',b:'',c:''}}) 37 > object.bsonsize({a:{a:'',b:''}}) 29 > object.bsonsize({a:{a:''}}) 21  > object.bsonsize({a:"{a:'',b:'',c:''}"}) 29 > object.bsonsize({a:"{a:'',b:''}"}) 24 > object.bsonsize({a:"{a:''}"}) 19  > object.bsonsize({a:""}) 13 > object.bsonsize({ab:""}) 14 > object.bsonsize({abc:""}) 15

it looks me empty doc 5 byte 1 empty string 7 byte plus each character in name 1 byte , each in content 1 byte.


Comments

Post a Comment

Popular posts from this blog

Unable to remove the www from url on https using .htaccess -

-
i want remove www site url. ie. https://www.domainname.com.au https://domainname.com.au . i have tried various .htacces code nothing work me. here present code remove www http not work https. rewriteengine on rewritebase / rewritecond %{http_host} ^www\.(.*)$ [nc] rewriterule ^/(.*)$ http://%1/$1 [r=301,l] rewritecond %{https} off rewriterule ^(.*)$ https://domainname.com.au/$1 [r=301,l] rewriterule ^code-of-conducts/(.*)/$ code-of-conducts.php?type=$1 rewriterule ^parents/post-a-job/(.*)/edit/$ parents/post-a-job.php?action=edit&id=$1 rewriterule ^parents/post-a-job/(.*)/$ parents/post-a-job.php?job_type=$1 rewriterule ^parents/open-jobs/(.*)/delete/$ parents/open-jobs.php?action=delete&id=$1 rewriterule ^parent-profile/(.*)/$ parent-profile.php?id=$1 rewriterule ^parents/job-details/(.*)$ parents/job-details.php?applied_id=$1 rewriterule ^sitterprofile/(.*)/$ sitterprofile.php?id=$1 rewriterule ^sitter/job-board/state/(.*)/page/(.*)/$ sitter/job-board.ph...
Read more