[JDEV] BIG Roster in Jabber

Murali P Murali_P at Sifycorp.com
Fri Sep 6 00:37:25 CDT 2002

Hi All,
     This being the order (900 items in roster), the way xdb_sql has been
written is totally screwed.

It first does a select from the rosterusers table to fetch the list of jid's for
that username and then for each & every jid, it selects from rostergroups table
to get the group name.

So for every client while logging in it does a jabber:iq:roster, there would be
a minimum of 901 questions on the db :) & subsequently, whenever this client who
has now logged in wants to add/modify an existing buddy , jabber internally
would do a jabber.Iq:roster & fetch his current roster list , only to go into an
eternal sleep mode :) (this is the case for just one user)

As regards the functionality of buddy add's in the offline mode, it is better
not to comment as it does not work at all in xdb_sql (or atleast in mysql as


                                              Placed At :

Peter Saint-Andre <stpeter at jabber.org> on 09/06/2002 03:54:37 AM

Please respond to jdev at jabber.org

To:   "Jdev (E-mail)" <jdev at jabber.org>
cc:    (bcc: Murali P/Satyam)

Subject:  Re: [JDEV] BIG Roster in Jabber

I agree with temas -- large rosters cause a lot of packets to fly around
in the server, so it's better to write this as a component. My roster (900
items) probably hogs ridiculous amounts of memory. Maybe I need to be a
component. :)

Anyone have a good roster-cleaner? Maybe I need to write one...


Peter Saint-Andre
Jabber Software Foundation

On Tue, 3 Sep 2002, Agustin Sanchez wrote:

> Hi All:
> I'd like to know if it's possible to store a really big user roster in a
> jabber server (could be as much as 5000/6000 users). This is meant to have a
> large distribution list send information to users who subscribe a news
> service implemented on jabber. How about the MSN transport? Does this
> imposes any limitation on the number of users?
> Thanks in advance
> Agustin Sanchez

jdev mailing list
jdev at jabber.org

More information about the JDev mailing list