[JDEV] Jabber and user database

[raditha dissanayake]

Hi,
my experience is that xdb_sql is a triffle slower than xdb_file. However 
i haven't had it dying on me like this.
One of the reasons for the performance drop is that when ever you add or 
remove a roster item the whole roster is created and inserted again.
That is if you have 25 memebers in your roster and you add another, 
there will be one delete followed by 26 inserts!!
However this is NOT a shortcoming of xdb_sql, xdb_file needs this 
behaviour and xdb_sql has to live with it.
The good news is that you can tweak things a bit and eliminate all these 
extra inserts.


Yanming Xiao wrote:

>Hi guys,
>
>How the performance of xdb_sql? I am runing it with jabber-1.4.2 on RH 7.3,
>but it always causes sudden death of jabber when a new user tries
>to register.
>
>-Yanming
>
>----- Original Message -----
>From: "raditha dissanayake" <jabber at raditha.com>
>To: <jdev at jabber.org>
>Sent: Saturday, November 09, 2002 2:42 PM
>Subject: Re: [JDEV] Jabber and user database
>
>
>  
>
>>Hi Bart,
>>I have good news for you, xdb_sql is extremely flexible with it's
>>database design. In fact it's not an exageration to say the database
>>structure is completely abtracted from the xdb_sql code. All the queries
>>are defined in xdb_sql.xml and you can change this so that it can work
>>with your phpdb database.
>>
>>btw: can i join your phpdb jabber integration effort?
>>
>>
>>Bart van Bragt wrote:
>>
>>    
>>
>>>Master Brian wrote:
>>>      
>>>
>>>>I hope that I can use a user database that I've already in use under
>>>>MySql. The user database is mantained by my forum, made in phpbb (do
>>>>        
>>>>
>>>you
>>>      
>>>
>>>>know it?).
>>>>        
>>>>
>>>I'm one of the senior developers of phpBB. I've been playing with the
>>>same idea. Haven't had time to implement this yet. Main reason is that
>>>I don't want to run jabberd on my main server (on domain.com) to do
>>>that my client (Psi) first needs to support SRV DNS entries.
>>>
>>>When this is done I'm probably going to try to accomplish this. I
>>>already saw that jabberd can use MySQL for keeping track of things. I
>>>don't know how trivial it would be to link the phpBB user table with
>>>the Jabberd process. Of course you could alter profile.php to make it
>>>insert/delete/update approriate rows when a user creates, deletes or
>>>alters a username.
>>>
>>>BTW you will have to make some modifications to phpBB. You'll at least
>>>need to limit the usernames that users can't choos (i.e. disallow
>>>spaces, etc).
>>>
>>>Curious if someone else can tell us how (non-)trivial it would be to
>>>link jabberd to another user database.
>>>
>>>      
>>>
>>_______________________________________________
>>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
>  
>