[JDEV] Jabber and user database

[Daniel Chote]

Actually.. I found that this issue occurs when a client probes for a 
namespace that is not handeled by the jabber server, when your using 
xdb_sql..

The thing I found that did it was iq:private, when a client requested 
iq:private, jabberd would sit there and do nothing until the xdb request 
timed out... the solution to this was to run xdb_sql along side 
xdb_file, and map the relevant  namespaces to each.

raditha dissanayake wrote:

> 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
>>  
>>
>
>
> _______________________________________________
> jdev mailing list
> jdev at jabber.org
> http://mailman.jabber.org/listinfo/jdev


-- 

*. Daniel Chote*
email/jabber: daniel at chote.net
web: www.chote.net

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://www.jabber.org/jdev/attachments/20021113/fdbb4015/attachment-0002.htm>