 |
|
Topic started on 3-6-2003 @ 03:32 PM by William
|
Within the next 24 hours, all U2U's that are more than 30 days old will be removed from the system. We have an overwhelming number of U2U messages
being stored by users... so many that our database temporarily locked up yesterday (XMB never anticipated more than 32,000 U2U messages). While I've
increased the number of U2U's the system allows, we still have far too many.
I'm also going to be removing users that have 0 posts, and have not been on the site in the past 60 days. So if you're a lurker and want to keep
your profile... POST SOMETHING!
Thank you.
|
reply to this post:
copyright & usage
|
 |
reply posted on 3-6-2003 @ 03:35 PM by ultra_phoenix
|
Nothing beat a good purge. Ask to Stalin or Mao 
|
reply to this post:
copyright & usage
|
|
reply posted on 3-6-2003 @ 03:37 PM by Leveller
|
It's lucky that there are no "intellectuals" around here. 
|
reply to this post:
copyright & usage
|
|
reply posted on 3-6-2003 @ 03:40 PM by John bull 1
|
Another good move.Alot of those 0 poster have just left the website address just to get a few more hits.
|
reply to this post:
copyright & usage
|
|
reply posted on 3-6-2003 @ 04:37 PM by Netchicken
|
If it craps out at 32000 then the data field is set to "integer", you could set it to "long" (if it supports it) to get more grunt in terms of
storage
[Edited on 3-6-2003 by Netchicken]
|
reply to this post:
copyright & usage
|
|
reply posted on 3-6-2003 @ 04:57 PM by William
|
Yup... trouble was the data field was also the auto-increment primary key... so changing and active primary key field required a bit of a deft touch.
|
reply to this post:
copyright & usage
|
|
reply posted on 3-6-2003 @ 05:06 PM by David
|
ouch, what fields are set as indexed? i know that DB's screw up royaly if theres too many of those.
|
reply to this post:
copyright & usage
|
|
reply posted on 3-6-2003 @ 07:26 PM by William
|
Actually... the XMB tables are apparently not indexed... that's coming soon, enabled the relational capabilities of the new mySQL, and indexing the
tables.
The Member databse purge went without trouble. Moving on to U2U's.
|
reply to this post:
copyright & usage
|
|
reply posted on 3-6-2003 @ 07:33 PM by Illmatic67
|
Another wise move by our Staff.
Good Job Admins and Mods. 
|
reply to this post:
copyright & usage
|
|
reply posted on 3-6-2003 @ 07:48 PM by William
|
And U2U's are purged.
Don't come running to me because you lost your love letters. 
|
reply to this post:
copyright & usage
|
|
reply posted on 3-6-2003 @ 07:49 PM by Illmatic67
|
Mine are still there...
|
reply to this post:
copyright & usage
|
|
reply posted on 3-6-2003 @ 07:54 PM by Netchicken
|
... Illmatic you didn't tell us you were getting love letters 
|
reply to this post:
copyright & usage
|
|
reply posted on 3-6-2003 @ 08:13 PM by David
|
I made him promise not to tell anyone
|
reply to this post:
copyright & usage
|
|
reply posted on 3-6-2003 @ 08:19 PM by Ocelot
|
Great idea..... I have a couple of U2U's stored so Ill go and delete the ones I dont need now.
|
reply to this post:
copyright & usage
|
|
reply posted on 3-6-2003 @ 08:20 PM by Illmatic67
|
Ahhh shucks, I guess the secret is out now.... 
|
reply to this post:
copyright & usage
|
|
reply posted on 3-6-2003 @ 08:23 PM by David
|
Yes, Yes it is, now you owe me dinner and flowers....or a nice 120gb Seagate hard drive
|
reply to this post:
copyright & usage
|
|
reply posted on 8-6-2003 @ 02:47 PM by CiderGood_HeadacheBad
|
Looking through the membership list last night I realised that there are literally dozens of members who have been inactive for months, having only
made 1 or 2 posts 
|
reply to this post:
copyright & usage
|
|
reply posted on 9-6-2003 @ 12:17 PM by f16falcon
|
good move delete them trolls
|
reply to this post:
copyright & usage
|
|
