Discussion on migrating-to-followers-and-notifications

1 view
Skip to first unread message

kosso

unread,
Oct 1, 2007, 9:03:10 PM10/1/07
to Twitter Development Talk
Why has the order of people I follow on my page 'quilt' changed from
being in alphabetical order?

Alex Payne

unread,
Oct 1, 2007, 9:07:08 PM10/1/07
to twitter-deve...@googlegroups.com
This group isn't for general questions about Twitter. Please contact
support for that at http://twitter.com/help

That said, the reason is that sorting the query that generates that
"quilt" alphabetically is expensive for our database, so we let it
determine its own most optimal sort order.

On 10/1/07, kosso <kos...@gmail.com> wrote:
>
> Why has the order of people I follow on my page 'quilt' changed from
> being in alphabetical order?
>
>


--
Alex Payne
http://twitter.com/al3x

funkatron

unread,
Oct 4, 2007, 6:46:17 AM10/4/07
to Twitter Development Talk

Click on http://groups.google.com/group/twitter-development-talk/web/migrating-to-followers-and-notifications
- or copy & paste it into your browser's address bar if that doesn't
work.

kosso

unread,
Oct 10, 2007, 6:33:48 AM10/10/07
to Twitter Development Talk
Sorry. I tried the help page but have had no response at all.

So what *is* the ordering now? user id?

Get a better database. Sorting things is what they are very good at, I
would say! ;p

On Oct 2, 2:07 am, "Alex Payne" <a...@al3x.net> wrote:
> This group isn't for general questions about Twitter. Please contact

> support for that athttp://twitter.com/help


>
> That said, the reason is that sorting the query that generates that
> "quilt" alphabetically is expensive for our database, so we let it
> determine its own most optimal sortorder.
>
> On 10/1/07, kosso <kos...@gmail.com> wrote:
>
>
>

> > Why has theorderof people I follow on my page 'quilt' changed from

Manuel González Noriega

unread,
Oct 10, 2007, 7:10:34 AM10/10/07
to twitter-deve...@googlegroups.com
On 10/10/2007, kosso <kos...@gmail.com> wrote:
>
> Sorry. I tried the help page but have had no response at all.
>
> So what *is* the ordering now? user id?
>
> Get a better database. Sorting things is what they are very good at, I
> would say! ;p

Yeah, clearly MS Access isn't cutting it for them anymore. They should
consider other options ASAP.


--
Manuel, que
piensa que eres una excelente persona y medra en torno a
http://simplelogica.net y/o http://simplelogica.net/logicola/
Recuerda comer mucha fruta y verdura.

Ed Finkler

unread,
Oct 10, 2007, 10:25:49 AM10/10/07
to twitter-deve...@googlegroups.com
On 10/10/07, Manuel González Noriega <manuel.gonz...@gmail.com> wrote:
>
> On 10/10/2007, kosso <kos...@gmail.com> wrote:
> > Get a better database. Sorting things is what they are very good at, I
> > would say! ;p
>
> Yeah, clearly MS Access isn't cutting it for them anymore. They should
> consider other options ASAP.

Wow, those are both deeply ignorant and prickish things to say.

While the issue is a complex one -- rarely helped by smarmy remarks by
people who have little idea of the specific challenges a particular
app is facing -- sorting large data sets can increase processing time
for a query exponentially. I suspect the decision to drop sorting in
that area was not one made lightly.

If the sort order offends you deeply, use Firefox and write a
Greasemonkey plugin to resort by screenname.

--
Ed Finkler
http://funkatron.com
AIM: funka7ron
ICQ: 3922133
Skype: funka7ron

Alex Payne

unread,
Oct 10, 2007, 12:57:15 PM10/10/07
to twitter-deve...@googlegroups.com
We're running MySQL on a monster Sun box with multiple cores, 32GB of
RAM, and just about everything spec'ed out to the max. Sorting by
anything except primary key still slows it down.

On 10/10/07, Manuel González Noriega <manuel.gonz...@gmail.com> wrote:
>

Manuel González Noriega

unread,
Oct 10, 2007, 1:35:19 PM10/10/07
to twitter-deve...@googlegroups.com

Ed,

My comment about MS Access was a joke targetting kosso's remarks
(which I in turn hope were a joke too). I'm sorry if the sarcasm
seemed targeted towards Twitter; it wasn't.

I'm well aware of Twitter's size, technical challenges and phenomenal
response to those.

Reply all
Reply to author
Forward
0 new messages