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 hodgson_sam@hotmail.com
 designates 157.55.2.11 as permitted sender)
Message-ID: <DUB116-W2131CBCF7E59D9A3B32A20995E0@phx.gbl>
Content-Type: multipart/alternative;
	boundary="_c3e54db6-a93e-4af4-97ad-3e4cd7740d0e_"
From: Sam Hodgson <hodgson_sam@hotmail.com>
To: <user@cassandra.apache.org>
Subject: RE: Pagination
Date: Tue, 27 Nov 2012 20:47:12 +0000
Importance: Normal
In-Reply-To: 
 <CAOBz8JaYb-6WTtMWpGnaZH+n5=Qt56DNPDxF8Wwu68KhkJ1_Gw@mail.gmail.com>
References: 
 <DUB116-W86BBD2D0A1952BE0C7AA7A995E0@phx.gbl>,<CAOBz8JaYb-6WTtMWpGnaZH+n5=Qt56DNPDxF8Wwu68KhkJ1_Gw@mail.gmail.com>
MIME-Version: 1.0

--_c3e54db6-a93e-4af4-97ad-3e4cd7740d0e_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable


Well I know what you mean and i have been doing that however im currently m=
igrating an old mysql site onto cass and just trying to keep things consist=
ent on the front end for the guy=2C i thought i might be missing a trick bu=
t if not then yeah I may well ditch the page linkage if it starts causing p=
roblems.
Cheers
Sam

Date: Tue=2C 27 Nov 2012 13:01:48 -0700
Subject: Re: Pagination
From: derek@fyrie.net
To: user@cassandra.apache.org

Do you really require page numbers? I usually find them annoying while pagi=
ng through a forum=2C especially if it is quite active. Threads from the bo=
ttom of the page get bumped to the next page so you end up seeing the same =
content again. I much prefer the first page being the current N results=2C =
and the next page being the next N results after the last updated time of t=
he last thread on the page. It is also much easier to model with Cassandra.


On Tue=2C Nov 27=2C 2012 at 12:19 PM=2C Sam Hodgson <hodgson_sam@hotmail.co=
m> wrote:


Hi All=2C
Wondering if anyone has any good solutions to pagination? In particular enu=
merating the number of pages and linking to each page=2C a common feature i=
n forums.

This code is untested (using phpcassa) and may need tweaking to get the cor=
rect range of records or maybe completely wrong! however it shows the conce=
pt of taking a page number then pulling out a range of posts belonging to t=
hat page:

$cf_threads looks like:thread_ID =3D> (timestamp =3D> post_id)
if($page > 1)        {        $ranger =3D ($pagenumber * 20)=3B        $low=
_ranger =3D $ranger - 20=3B
        $arr_range =3D $cf_threads->get("$thread_id" =2C $columns=3Dnull =
=2C  $column_start=3D"" =2C $column_finish=3D"" =2C $column_reversed=3DTrue=
=2C $limit=3D$ranger)=3B        $arr_page =3D array_slice($arr_range=2C $lo=
w_ranger =2C $ranger =2C TRUE)=3B
        }else                {                $arr_page =3D $cf_threads->ge=
t("$thread_id" =2C $columns=3Dnull =2C  $column_start=3D"" =2C $column_fini=
sh=3D"" =2C $column_reversed=3DTrue=2C $limit=3D20)=3B
                }
I think this should be ok? the only concern is if there are some really lon=
g threads when im having to pull the entire CF.
Another idea involved a schema change and using a super CF to include a pag=
e number as follows:

Thread_ID =3D> (PageNumber(timestamp =3D> Post_ID))
Probably more efficient but generally page numbers go backwards ie page 1 h=
as newest content so this would complicate things when writing data and cau=
se load if logic was included to reorganise page numbers etc.

Cheers
Samhttp://Newsarc.net 		 	   		 =20


--=20
Derek Williams

 		 	   		  =

--_c3e54db6-a93e-4af4-97ad-3e4cd7740d0e_
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<html>
<head>
<style><!--
.hmmessage P
{
margin:0px=3B
padding:0px
}
body.hmmessage
{
font-size: 10pt=3B
font-family:Tahoma
}
--></style></head>
<body class=3D'hmmessage'><div dir=3D'ltr'>
Well I know what you mean and i have been doing that however im currently m=
igrating an old mysql site onto cass and just trying to keep things consist=
ent on the front end for the guy=2C i thought i might be missing a trick bu=
t if not then yeah I may well ditch the page linkage if it starts causing p=
roblems.<div><br></div><div>Cheers</div><div><br></div><div>Sam<br><div><br=
></div><div><div>Date: Tue=2C 27 Nov 2012 13:01:48 -0700<br>Subject: Re: Pa=
gination<br>From: derek@fyrie.net<br>To: user@cassandra.apache.org<br><br>D=
o you really require page numbers? I usually find them annoying while pagin=
g through a forum=2C especially if it is quite active. Threads from the bot=
tom of the page get bumped to the next page so you end up seeing the same c=
ontent again. I much prefer the first page being the current N results=2C a=
nd the next page being the next N results after the last updated time of th=
e last thread on the page. It is also much easier to model with Cassandra.<=
div class=3D"ecxgmail_extra">
<br><br><div class=3D"ecxgmail_quote">On Tue=2C Nov 27=2C 2012 at 12:19 PM=
=2C Sam Hodgson <span dir=3D"ltr">&lt=3B<a href=3D"mailto:hodgson_sam@hotma=
il.com">hodgson_sam@hotmail.com</a>&gt=3B</span> wrote:<br><blockquote clas=
s=3D"ecxgmail_quote" style=3D"border-left:1px #ccc solid=3Bpadding-left:1ex=
">


<div><div dir=3D"ltr">
<div>Hi All=2C</div><div><br></div><div>Wondering if anyone has any good so=
lutions to pagination? In particular enumerating the number of pages and li=
nking to each page=2C a common feature in forums.</div><div><br></div><div>
This code is untested (using phpcassa) and may need tweaking to get the cor=
rect range of records or maybe completely wrong! however it shows the conce=
pt of taking a page number then pulling out a range of posts belonging to t=
hat page:</div>
<div><br></div><div>$cf_threads looks like:</div><div>thread_ID =3D&gt=3B (=
timestamp =3D&gt=3B post_id)</div><div><br></div><div>if($page &gt=3B 1)</d=
iv><div>&nbsp=3B &nbsp=3B &nbsp=3B &nbsp=3B {</div><div>&nbsp=3B &nbsp=3B &=
nbsp=3B &nbsp=3B $ranger =3D ($pagenumber * 20)=3B</div><div>&nbsp=3B &nbsp=
=3B &nbsp=3B &nbsp=3B $low_ranger =3D $ranger - 20=3B</div>
<div>&nbsp=3B &nbsp=3B &nbsp=3B &nbsp=3B $arr_range =3D $cf_threads-&gt=3Bg=
et("$thread_id" =2C $columns=3Dnull =2C &nbsp=3B$column_start=3D"" =2C $col=
umn_finish=3D"" =2C $column_reversed=3DTrue=2C $limit=3D$ranger)=3B</div><d=
iv>&nbsp=3B &nbsp=3B &nbsp=3B &nbsp=3B $arr_page =3D array_slice($arr_range=
=2C $low_ranger =2C $ranger =2C TRUE)=3B</div>
<div>&nbsp=3B &nbsp=3B &nbsp=3B &nbsp=3B }else</div><div>&nbsp=3B &nbsp=3B =
&nbsp=3B &nbsp=3B &nbsp=3B &nbsp=3B &nbsp=3B &nbsp=3B {</div><div>&nbsp=3B =
&nbsp=3B &nbsp=3B &nbsp=3B &nbsp=3B &nbsp=3B &nbsp=3B &nbsp=3B $arr_page =
=3D $cf_threads-&gt=3Bget("$thread_id" =2C $columns=3Dnull =2C &nbsp=3B$col=
umn_start=3D"" =2C $column_finish=3D"" =2C $column_reversed=3DTrue=2C $limi=
t=3D20)=3B</div>
<div>&nbsp=3B &nbsp=3B &nbsp=3B &nbsp=3B &nbsp=3B &nbsp=3B &nbsp=3B &nbsp=
=3B }</div><div><br></div><div>I think this should be ok? the only concern =
is if there are some really long threads when im having to pull the entire =
CF.</div><div><br></div><div>Another idea involved a schema change and usin=
g a super CF to include a page number as follows:</div>
<div><br></div><div>Thread_ID =3D&gt=3B (PageNumber(timestamp =3D&gt=3B Pos=
t_ID))</div><div><br></div><div>Probably more efficient but generally page =
numbers go backwards ie page 1 has newest content so this would complicate =
things when writing data and cause load if logic was included to reorganise=
 page numbers etc.</div>
<div><br></div><div>Cheers</div><div><br></div><div>Sam</div><div><a href=
=3D"http://Newsarc.net" target=3D"_blank">http://Newsarc.net</a></div> 		 	=
   		  </div></div>
</blockquote></div><br><br clear=3D"all"><div><br></div>-- <br><div>Derek W=
illiams</div><br>
</div></div></div></div> 		 	   		  </div></body>
</html>=

--_c3e54db6-a93e-4af4-97ad-3e4cd7740d0e_--