[JDEV] BIG Roster in Jabber

[Glenn MacGregor]

----- Original Message -----
From: "Murali P" <Murali_P at sifycorp.com>
To: <jdev at jabber.org>
Sent: Friday, September 06, 2002 1:37 AM
Subject: Re: [JDEV] BIG Roster in Jabber


>
>
>
> 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)

I have made some fixes to xdb_sql for this problem.  The first one is easily
fixed by putting a join in that select statement so there is only one call
to the db.  I have not see the second problem, but if you elaborate a bit I
can test it and post a fix.

>
> 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
> db).
>
>
> Regards
> P.Murali
>
>
>
>                                               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
>
> --
> Peter Saint-Andre
> Jabber Software Foundation
> http://www.jabber.org/people/stpeter.html
>
> 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
> http://mailman.jabber.org/listinfo/jdev
>
>
>
>
>
>
>
> _______________________________________________
> jdev mailing list
> jdev at jabber.org
> http://mailman.jabber.org/listinfo/jdev
>