Thought as much, but wanted someone to give me a convincing reply so that we can make a better decision.<br><br>Thanks for the quick reply!<br><br><div class="gmail_quote">On Tue, Dec 9, 2008 at 4:16 PM, Simon Hobson <span dir="ltr"><<a href="mailto:linux@thehobsons.co.uk">linux@thehobsons.co.uk</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div class="Ih2E3d">Gautham Pai wrote:<br>
<br>
>We are trying to see if RRDTool is a good fit to build a popularity<br>
>service for a social network.<br>
<br>
</div>No, I don't think it will help you much, if at all.<br>
<div class="Ih2E3d"><br>
>The requirements are:<br>
>A unique score is given to every user based on various factors. The<br>
>number of such users could run into millions. We then feed this<br>
>score along with the userids to a datastore. We should then be able<br>
>to query the store for answers to questions like:<br>
>* Who are the top 5 active users in the network?<br>
<br>
</div>RRD won't tell you that, you'd have to write a script to extract the<br>
data and sort it.<br>
<div class="Ih2E3d"><br>
>* Who are the top 5 active users in the last one month and how has<br>
>their activity changed in the last week?<br>
<br>
</div>Ditto, RRD won't find the top users for you, but once you've found<br>
them then it could tell your what their activity has been.<br>
<div class="Ih2E3d"><br>
>I read that RRDTool allows only numeric data to be captured. But we<br>
>need some book-keeping data too that needs to be stored and<br>
>retrieved later.<br>
<br>
</div>Correct, only numeric data is held, and the data elements are static<br>
- eg you cannot store (user, date/time, activity) tuples. You would<br>
have to either store a separate database for each user (that's a LOT<br>
of files), or stuff LOTS of users into one file (really hard to<br>
manage), or keep a number of files each of which stores data for a<br>
number of users (also very hard to manage).<br>
<div class="Ih2E3d"><br>
>Is it possible to build such a service using RRDTool?<br>
<br>
</div>To be honest, I think the work involved in making it fit your needs<br>
would be more than using a common relational database which would<br>
probably be able to return most of the information you want using<br>
it's standard query facilities.<br>
<br>
--<br>
Simon Hobson<br>
<br>
Visit <a href="http://www.magpiesnestpublishing.co.uk/" target="_blank">http://www.magpiesnestpublishing.co.uk/</a> for books by acclaimed<br>
author Gladys Hobson. Novels - poetry - short stories - ideal as<br>
Christmas stocking fillers. Some available as e-books.<br>
<br>
_______________________________________________<br>
rrd-users mailing list<br>
<a href="mailto:rrd-users@lists.oetiker.ch">rrd-users@lists.oetiker.ch</a><br>
<a href="https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users" target="_blank">https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users</a><br>
</blockquote></div><br><br clear="all"><br>-- <br>Gautham Pai,<br>Software Engineer, weRead<br><br>Website: <a href="http://buzypi.in/">http://buzypi.in/</a><br>Blog: <a href="http://blog.buzypi.in/">http://blog.buzypi.in/</a><br>
weRead: <a href="http://weread.com/">http://weread.com/</a><br><br>"What's life without an impossible dream"<br>