Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
Received-SPF: pass (nike.apache.org: domain of adynnn@gmail.com designates
 209.85.212.172 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:date:message-id:subject:from:to:content-type;
        b=o42m5YcoW+RkGGXynCVFhatOQfSxb7slioCrkyqy1nq6E27r3R3YNEJhB6eKLxEs8H
         0/xDm3FDW4nn5rD4ZLHp91XRxOiwK4SbGbr9FzE50KJU6UjrqKyaO0KGgV3nh6NIVtXl
         CHrtG0PqU1OAqXtUjwrHYosO757uEIRx6wsbg=
MIME-Version: 1.0
Date: Tue, 8 Mar 2011 11:42:03 +0530
Message-ID: <AANLkTinVOnZZ16z=g1f8_EgiMSR6pKEwUj2T4FHEHXYE@mail.gmail.com>
Subject: Splitting the data of a single blog into 2 CFs (to implement
 effective caching) according to views.
From: Aditya Narayan <adynnn@gmail.com>
To: user <user@cassandra.apache.org>
Content-Type: multipart/alternative; boundary=000e0cd32ef8af9022049df27d67

--000e0cd32ef8af9022049df27d67
Content-Type: text/plain; charset=ISO-8859-1

My application  displays list of several blogs' overview data (like
blogTitle/ nameOfBlogger/ shortDescrption for each blog) on 1st page (in
very much similar manner like Digg's newsfeed) and when the user selects a
particular blog to see., the application takes him to that specific blog's
full page view which displays entire data of the blog.

Thus I am trying to split a blog's data in *two rows*, in two **different
CFs ** (one CF is row-cached(with less amount of data in each row) and
another(with each row having entire remaining blog data) without caching).

Data for 1st page view (like titles and other overview data of a blog) are
put in a row in 1st CF. This CF is cached so as to improve the performance
of heavily read data. Only the data from cached CF is read for 1st page. The
other remaining data(bulk amount of text of blog and entire comments data)
are stored as another row in 2nd CF. For 2nd page, **rows from both of the
two CFs have to be read**. This will take two read operations.

Does this seem to be a good design ?

--000e0cd32ef8af9022049df27d67
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

<br>My application=A0 displays list of several blogs&#39; overview data (li=
ke blogTitle/ nameOfBlogger/ shortDescrption for each blog) on 1st page (in=
 very much similar manner like Digg&#39;s newsfeed) and when the user selec=
ts a particular blog to see., the application takes him to that specific bl=
og&#39;s full page view which displays entire data of the blog. <br>
<br>Thus I am trying to split a blog&#39;s data in *two rows*, in two **dif=
ferent CFs ** (one CF is row-cached(with less amount of data in each row) a=
nd another(with each row having entire remaining blog data) without caching=
).<br>
<br>Data for 1st page view (like titles and other overview data of a blog) =
are put in a row in 1st CF. This CF is cached so as to improve the performa=
nce of heavily read data. Only the data from cached CF is read for 1st page=
. The other remaining data(bulk amount of text of blog and entire comments =
data)=A0 are stored as another row in 2nd CF. For 2nd page, **rows from bot=
h of the two CFs have to be read**. This will take two read operations.<br>
<br>Does this seem to be a good design ?<br>

--000e0cd32ef8af9022049df27d67--