It looks like you're using an Ad Blocker.

Please white-list or disable AboveTopSecret.com in your ad-blocking tool.

Thank you.

 

Some features of ATS will be disabled while you continue to use an ad-blocker.

 

ANNOUNCEMENT! Forum Purge Coming Soon

page: 1
0

log in

join
share:

posted on Jun, 3 2003 @ 03:32 PM
link   
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.



posted on Jun, 3 2003 @ 03:35 PM
link   
Nothing beat a good purge. Ask to Stalin or Mao



posted on Jun, 3 2003 @ 03:37 PM
link   
It's lucky that there are no "intellectuals" around here.



posted on Jun, 3 2003 @ 03:40 PM
link   
Another good move.Alot of those 0 poster have just left the website address just to get a few more hits.



posted on Jun, 3 2003 @ 04:37 PM
link   
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]



posted on Jun, 3 2003 @ 04:57 PM
link   
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.



posted on Jun, 3 2003 @ 05:06 PM
link   
ouch, what fields are set as indexed? i know that DB's screw up royaly if theres too many of those.



posted on Jun, 3 2003 @ 07:26 PM
link   
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.



posted on Jun, 3 2003 @ 07:33 PM
link   
Another wise move by our Staff.

Good Job Admins and Mods.



posted on Jun, 3 2003 @ 07:48 PM
link   
And U2U's are purged.

Don't come running to me because you lost your love letters.



posted on Jun, 3 2003 @ 07:49 PM
link   
Mine are still there...



posted on Jun, 3 2003 @ 07:54 PM
link   
... Illmatic you didn't tell us you were getting love letters



posted on Jun, 3 2003 @ 08:13 PM
link   
I made him promise not to tell anyone



posted on Jun, 3 2003 @ 08:19 PM
link   
Great idea..... I have a couple of U2U's stored so Ill go and delete the ones I dont need now.



posted on Jun, 3 2003 @ 08:20 PM
link   
Ahhh shucks, I guess the secret is out now....



posted on Jun, 3 2003 @ 08:23 PM
link   
Yes, Yes it is, now you owe me dinner and flowers....or a nice 120gb Seagate hard drive



posted on Jun, 8 2003 @ 02:47 PM
link   
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



posted on Jun, 9 2003 @ 12:17 PM
link   
good move delete them trolls



new topics

top topics



 
0

log in

join