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" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
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 underyou
MySql. The user database is mantained by my forum, made in phpbb (do
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
[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
--
• Daniel Chote
email/jabber: [EMAIL PROTECTED]
web: www.chote.net
