Re: which one of the following choices is more efficient?

@Benjamin Roth I think you kinda of answered my question. my use case is really that I need to store a SkipList like structure into one or multiple tables. I could map the entire skip list like structure into one table or I could map a list at every level into another table and the number of

Re: which one of the following choices is more efficient?

@Ali hmm..I didn't mean to say I store the same data across two tables and neither tables are dependent for me to do the writes twice. you can imagine tables are independent and the data is unique across tables but I could store data from multiple tables into one table. otherwords I am just

Re: which one of the following choices is more efficient?

If you have 2 tables that share the same PK and have few fields and most of the rows have values for all (or many fields), merging them could save you some space as for each table, each PK has to be stored in both tables. But I would avoid having "god tables" with too many fields. But at the end

Re: which one of the following choices is more efficient?

You would need to do each write twice and data will take up twice the space as its duplicated in two places. On Wed, Oct 26, 2016 at 1:17 PM, Kant Kodali wrote: > I guess the question can be rephrased into "What is the overhead of > creating and maintaining an additional

Re: which one of the following choices is more efficient?

I guess the question can be rephrased into "What is the overhead of creating and maintaining an additional table?" On Wed, Oct 26, 2016 at 1:12 AM, Ali Akhtar wrote: > Depends on the use case. No one right answer. > > On Wed, Oct 26, 2016 at 1:03 PM, Kant Kodali

Re: which one of the following choices is more efficient?

Depends on the use case. No one right answer. On Wed, Oct 26, 2016 at 1:03 PM, Kant Kodali wrote: > If one were given a choice of fitting all the data into one table vs > fitting the data into two tables while say (keeping all the runtime and > space complexity for CRUD

which one of the following choices is more efficient?

If one were given a choice of fitting all the data into one table vs fitting the data into two tables while say (keeping all the runtime and space complexity for CRUD operations the same in either case) which one would you choose and why?