[COUCHDB-3215] Differet size for the same view

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Won't Fix
• Component/s: Database Core, JavaScript View Server
• Assignee: Unassigned
• Reporter: Raphael Augusto da Silva Nunes Soransso
• Created: 27/Oct/16 12:24
• Updated: 02/Sep/18 07:06
• Resolved: 02/Sep/18 07:06

Description

Hi, I have created two structure for a set of data to analyse if it would make the queries faster, one data was created using a different table, from relational database, as the root of the documents:
Example:
One struture is like this:
{
"c_customer_sk": 65836,
"c_first_name": "Frank",
"c_last_name": "White",
"store_sales": [ {
"ss_sales_price": 20.24,
"ss_ext_sales_price": 1012,
"ss_coupon_amt": 0,
"date": [

{ "d_month_seq": 1187, "d_year": 1998 }

],
"item": [

{ "i_item_sk": 10454, "i_item_id": "AAAAAAAAGNICAAAA", "i_item_desc": "Results highlight as patterns; so right years show. Sometimes suitable lips move with the critics. English, old mothers ought to lift now perhaps future managers. Active, single ch", "i_current_price": 2.88, "i_class": "romance", "i_category_id": 9, "i_category": "Books" }

] },
{
"ss_sales_price": 225,
"ss_ext_sales_price": 1023,
"ss_coupon_amt": 0,...

The other organization for the same data is:
{
"i_item_sk": 10454,
"i_item_id": "AAAAAAAAGNICAAAA",
"i_item_desc": "Results highlight as patterns; so right years show. Sometimes suitable lips move with the critics. English, old mothers ought to lift now perhaps future managers. Active, single ch",
"i_current_price": 2.88,
"i_class": "romance",
"i_category_id": 9,
"i_category": "Books",
"store_sales": [
{
"ss_sales_price": 20.24,
"ss_ext_sales_price": 1012,
"ss_coupon_amt": 0,
"date": [

{ "d_month_seq": 1187, "d_year": 1998 }

],
"customer": [

{ "c_customer_sk": 65836, "c_first_name": "Frank", "c_last_name": "White", }

]
},
{
"ss_sales_price": 225,
"ss_ext_sales_price": 1023,
"ss_coupon_amt": 0,...

If I create the same view for both data, their data_sizes are different, can someone explain me why?
I have posted it on stackoverflow too: http://stackoverflow.com/questions/38509074/different-size-for-the-same-view-on-couchdb/38521448#38521448