Re: database design

2011-04-14 Thread aaron morton
In some cases you may be able to add a secondary index. Aaron On 14 Apr 2011, at 03:11, Edward Capriolo wrote: > On Wed, Apr 13, 2011 at 10:39 AM, Jean-Yves LEBLEU wrote: >> Hi all, >> >> Just some thoughts and question I have about cassandra data modeling. >> >> If I understand well, cassan

Re: database design

2011-04-13 Thread Victor Kabdebon
Dear Jean-Yves, You can have a different approach of the problem. You need on one side a relational database (MySQL, PostGreSQL) or SolR (as an very efficient index) and on the other side Cassandra. The relational database or SolR must contain the minimum amount of information possible : a date an

Re: database design

2011-04-13 Thread Edward Capriolo
On Wed, Apr 13, 2011 at 10:39 AM, Jean-Yves LEBLEU wrote: > Hi all, > > Just some thoughts and question I have about cassandra data modeling. > > If I understand well, cassandra is better on writing than on reading. > So you have to think about your queries to design cassandra schema. We > are doi