----- Original Message ----- From: "Murali P" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> on 09/06/2002 03:54:37 AM > > Please respond to [EMAIL PROTECTED] > > To: "Jdev (E-mail)" <[EMAIL PROTECTED]> > 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 > [EMAIL PROTECTED] > http://mailman.jabber.org/listinfo/jdev > > > > > > > > _______________________________________________ > jdev mailing list > [EMAIL PROTECTED] > http://mailman.jabber.org/listinfo/jdev > _______________________________________________ jdev mailing list [EMAIL PROTECTED] http://mailman.jabber.org/listinfo/jdev
