Hi Matthias,
You could be right about the index being forgotten :-) and you are right
about making an index with a smaller width than the full column. But i
haven't seen such a drastic drop in performance as you seem to have
encountered without indices.
One other point that i noted is that mos
Hi Raditha!
Raditha Dissanayake schrieb am 2003-09-05 19:20:00:
> I guess Bentoit and Co might have left the tables without indices
> because there's a large number of inserts being done on these tables.
> That's because mod_roster passes the entire roster to XDB when a change
> occurs. xdb_sq
Hello Matthias
You are hardly the person we expect to ask questions on this list :-)
I guess Bentoit and Co might have left the tables without indices
because there's a large number of inserts being done on these tables.
That's because mod_roster passes the entire roster to XDB when a change
Hi!
I have some suggestions for the database schema of xdb_sql.
- At least in the MySQL version the table rostergroups has no index.
Therefore a query has to read the complete table. Adding a index on
username and jid improves the query speed very much.
CREATE INDEX rostergrpuserjid ON ros