Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
Received-SPF: pass (athena.apache.org: domain of rajkumar.w93@gmail.com
 designates 209.85.161.44 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:sender:date:x-google-sender-auth:message-id:subject
         :from:to:content-type;
        b=OOuYIiSvCNJXofpOaUk4SFCkUTp+I7WBQ6QgYWlrboWmGIjWUA1nSYczTz5wa9OFs6
         hoTcBJ2PzfL0cKX+gZc/Hdqb2QVlwwsXwT1rs3Gzt15uBX8v+If++7GVNeFI7+iHm4ea
         x1aZfDOSdZHgJEVeBWe0rvNGkZDcGnD/0uAb0=
MIME-Version: 1.0
Sender: rajkumar.w93@gmail.com
Date: Wed, 18 May 2011 23:04:49 +0530
Message-ID: <BANLkTinhmXaNNT75iokinNA=Rj_NMHE1yQ@mail.gmail.com>
Subject: Design for 'Most viewed Discussions' in a forum
From: Aditya Narayan <adynnn@gmail.com>
To: user <user@cassandra.apache.org>
Content-Type: multipart/alternative; boundary=00151747378835f85e04a3904e4f

--00151747378835f85e04a3904e4f
Content-Type: text/plain; charset=ISO-8859-1

*************
For a discussions forum, I need to show a page of most viewed discussions.

For implementing this, I maintain a count of views of a discussion & when
this views count of a discussion passes a certain threshold limit, the
discussion Id is added to a row of most viewed discussions.

This row of most viewed discussions contains columns with Integer names &
values containing serialized lists of Ids of all discussions whose views
count equals the Integral name of this column.

Thus if the view count of a discussion increases I'll need to move its 'Id'
from serialized list in some column to serialized list in another column
whose name represents the updated views count on that discussion.

Thus I can get the most viewed discussions by getting the appropriate no of
columns from one end of this Integer sorted row.

************

I wanted to get feedback from you all, to know if this is a good design.

Thanks

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

*************<br>For a discussions forum, I need to show a page of most vie=
wed discussions.<br><br>For implementing this, I maintain a count of views =
of a discussion &amp; when this views count of a discussion passes a certai=
n threshold limit, the discussion Id is added to a row of most viewed discu=
ssions. <br>
<br>This row of most viewed discussions contains columns with Integer names=
 &amp; values containing serialized lists of Ids of all discussions whose v=
iews count equals the Integral name of this column.<br><br>Thus if the view=
 count of a discussion increases I&#39;ll need to move its &#39;Id&#39; fro=
m serialized list in some column to serialized list in another column whose=
 name represents the updated views count on that discussion.<br>
<br>Thus I can get the most viewed discussions by getting the appropriate n=
o of columns from one end of this Integer sorted row.<br><br>************<b=
r><br>I wanted to get feedback from you all, to know if this is a good desi=
gn.<br>
<br>Thanks<br><br><br><br><br><br>

--00151747378835f85e04a3904e4f--