What would be the best approach A) millions of ~2Kb rows, where each row could have ~6 columns B) hundreds of ~100Gb rows, where each row could have ~1million columns
Considerarions: Most entries will be searched for (read+write) at least once a day but no more than 3 times a day. Cheap hardware accross the cluster of 3 nodes each with 16Gb mem (heap = 8Gb) Any input would be appreciated M.