<html><body><div style="color:#000; background-color:#fff; font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:10pt"><div id="yiv7398074036"><div><div style="color: rgb(0, 0, 0); background-color: rgb(255, 255, 255); font-family: HelveticaNeue, 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 10pt;"><div id="yiv7398074036yui_3_13_0_ym1_12_1385994274155_11"><span id="yiv7398074036yui_3_13_0_ym1_12_1385994274155_23">Thanks Frederik for kicking this off, good discussion of a *potentially* v useful feature.</span></div><div id="yiv7398074036yui_3_13_0_ym1_12_1385994274155_11" style="color: rgb(0, 0, 0); font-size: 13.63636302947998px; font-family: HelveticaNeue, 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; background-color: transparent; font-style: normal;"><span id="yiv7398074036yui_3_13_0_ym1_12_1385994274155_26"><br clear="none"></span></div><div
id="yiv7398074036yui_3_13_0_ym1_12_1385994274155_11" style="color: rgb(0, 0, 0); font-size: 13.63636302947998px; font-family: HelveticaNeue, 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; background-color: transparent; font-style: normal;"><span id="yiv7398074036yui_3_13_0_ym1_12_1385994274155_29">No matter how nearby users presentation is tweaked and filtered, I reckon we need consider how to architect this efficiently. To calculate "activity", by changesets or sign up date or any other parameters, using rails models or directly in SQL will be even slower than currently. I'm not familiar with exactly how Pascal does his calculations, but I'm guessing it's based on planet diffs and API queries when needed, with results stored. I'd love to see Pascal's system integrated into OSM.org, on both the friends and nearby users views (our "news feed"), and on user profile pages.</span></div><div
id="yiv7398074036yui_3_13_0_ym1_12_1385994274155_11" style="color:rgb(0, 0, 0);font-size:13.63636302947998px;font-family:HelveticaNeue, 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;background-color:transparent;font-style:normal;" class="yui_3_13_0_ym1_1_1385994274155_68008"><span><br></span></div><div id="yiv7398074036yui_3_13_0_ym1_12_1385994274155_11" style="color:rgb(0, 0, 0);font-size:13.63636302947998px;font-family:HelveticaNeue, 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;background-color:transparent;font-style:normal;" class="yui_3_13_0_ym1_1_1385994274155_68008"><span>What's the best way to set up this kind of async stats processing, and integrate into the rails app?</span></div><div id="yiv7398074036yui_3_13_0_ym1_12_1385994274155_11" style="color:rgb(0, 0, 0);font-size:13.63636302947998px;font-family:HelveticaNeue, 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande',
sans-serif;background-color:transparent;font-style:normal;" class="yui_3_13_0_ym1_1_1385994274155_68008"><span><br></span></div><div id="yiv7398074036yui_3_13_0_ym1_12_1385994274155_11" style="color:rgb(0, 0, 0);font-size:13.63636302947998px;font-family:HelveticaNeue, 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;background-color:transparent;font-style:normal;" class="yui_3_13_0_ym1_1_1385994274155_68008"><span>-Mikel</span></div><div id="yiv7398074036yui_3_13_0_ym1_12_1385994274155_13"></div><div id="yiv7398074036yui_3_13_0_ym1_12_1385994274155_15"> </div><div id="yiv7398074036yui_3_13_0_ym1_12_1385994274155_17">* Mikel Maron * +14152835207 @mikel s:mikelmaron</div><div class="yiv7398074036yahoo_quoted" id="yiv7398074036yui_3_13_0_ym1_12_1385994274155_19" style="display: block;"> <br clear="none"> <br clear="none"> <div class="yiv7398074036yui_3_13_0_ym1_1_1385994274155_61021" style="font-family: HelveticaNeue, 'Helvetica
Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 10pt;"> <div class="yiv7398074036yui_3_13_0_ym1_1_1385994274155_61022" style="font-family: HelveticaNeue, 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12pt;"> <div class="yiv7398074036yqt1168720306" id="yiv7398074036yqtfd84541"><div dir="ltr"> <font size="2" face="Arial"> On Tuesday, November 19, 2013 5:48 AM, Pieren <pieren3@gmail.com> wrote:<br clear="none"> </font>
</div> <blockquote style="border-left:2px solid rgb(16, 16, 255);margin-left:5px;margin-top:5px;padding-left:5px;"> <div class="yiv7398074036y_msg_container">For performance issues, it is probably easier and faster to sort by<br clear="none">last edit. Profile pages are already slow to open.<br clear="none"><br clear="none">On the other hand, the map could change the marker colour based on the<br clear="none">same attribut, either with a gray scale from black to almost<br clear="none">transparent or from 'red' or 'bright' for the most recent to 'gloomy'<br clear="none">or 'dark' for the oldest ones.<br clear="none"><br clear="none">My 2 cents,<br clear="none">Pieren<div class="yiv7398074036yqt0157133340" id="yiv7398074036yqtfd32468"><br clear="none"><br clear="none">_______________________________________________<br clear="none">talk mailing list<br clear="none"><a rel="nofollow" shape="rect" ymailto="mailto:talk@openstreetmap.org" target="_blank"
href="mailto:talk@openstreetmap.org">talk@openstreetmap.org</a><br clear="none"><a rel="nofollow" shape="rect" target="_blank" href="https://lists.openstreetmap.org/listinfo/talk">https://lists.openstreetmap.org/listinfo/talk</a><br clear="none"></div><br clear="none"><br clear="none"></div> </blockquote> </div></div><div class="yiv7398074036yqt1168720306" id="yiv7398074036yqtfd44548"> </div></div><div class="yiv7398074036yqt1168720306" id="yiv7398074036yqtfd13208"> </div></div><div class="yiv7398074036yqt1168720306" id="yiv7398074036yqtfd77512"> </div></div></div></div></div></body></html>