Just sharing some information that I though was interesting.
I've been doing a little database maintenance - stuff that has been put off forever on the OOoWiki.
There are 21906 user accounts in the Wiki database that have been created, but have never made a single edit in the Wiki. More than half of these accounts are for usernames that are random letter and number combinations (eg H1eht3gf8). There are huge sections of the report that show hundreds of usernames all exactly the same number of characters long, and all random characters. It looks like they were created by some bot or script.
I will delete all unused accounts older than 100 days from today (unless someone here objects). If someone hasn't edited a page and their account is more than 100 days old, chances are they are never coming back or have forgotten the account even exists.
I have rebuilt the tables and indexes - this should fix some of the minor issues such as Categories not reporting all member pages, or showing pages out of order in the Category view.
C. -- Clayton Cornell [email protected] OpenOffice.org Documentation Project co-lead StarOffice - Sun Microsystems, Inc. - Hamburg, Germany --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
