Least efficient way to load the data to memory

[prabhu pandurangan]

Hi Team,

Below is my sample data:


Key Col1(Str) Key Col2(Str) Key Col3(Str) Value Col1(int) Value Col2 (double) ------------------ ------------------- -------------------- ------------------- ---------------------------- key1 key11 key111 5 10.91 key1 key12 key112 7 12.1 key2 key12 key113 9 4.1 key3 key13 key114 2 -11.78 key3 key14 key114 0 21.45

Question 1: What would be the least efficient way to load the above data to memory?
Question 2: Assume if i have 1000 rows of the above table structure, how do we estimate the approx. memory size of the data structure?

[Campbell Ritchie]

Do you really mean least efficient?
That looks like really horrible design, unless you are inserting those data into a database. Create a class which encapsulates those 5 data. You can work out the sizes of the two primitives easily enough. Strings vary depending on their size. Add a few dozen bytes to create the objects and multiply by 1000.
Which is a waste of time, because even the smallest modern computer will have enough RAM to fit 1000000 objects like that it.

By the way: there is a way to make such tables show up nicely: code tags.