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.

 

Can't Cancel Membership?

page: 2
0
<< 1   >>

log in

join
share:

posted on May, 9 2006 @ 07:50 PM
link   

Originally posted by jsobecky
And I don't quite understand the potential data corruption thing when completely removing an account.


Apparently, relational databases are used. Meaning each table is related in some way with another. "Referential Integrity" requires that all relations stay valid and current. Deleting an account stored in one table, corrupts the relations to data stored in another, making everything else go.....??????




posted on May, 9 2006 @ 09:20 PM
link   

Originally posted by MrPenny

Originally posted by jsobecky
And I don't quite understand the potential data corruption thing when completely removing an account.


Apparently, relational databases are used. Meaning each table is related in some way with another. "Referential Integrity" requires that all relations stay valid and current. Deleting an account stored in one table, corrupts the relations to data stored in another, making everything else go.....??????


T'anks. I have some knowledge of DBMS and RDBMS, Oracle, and clusters,etc., (the true original clusters, VAXClusters!), and believe me, it is almost impossible to fool those systems. I've power-slammed many a system and it bounced right back after re-sync.

But of course I know nothing of what ATS is using, so all my observations may mean nothing.



posted on May, 10 2006 @ 11:04 AM
link   

Originally posted by jsobecky
But of course I know nothing of what ATS is using, so all my observations may mean nothing.


You're quite well on track here, so don't feel that way


The thing is, these forum software packages aren't really that bulletproof when it comes to database operations. It's quite easy to run into problems when doing large-scale modifications, if that operation keeps a table locked for a long time and other instances are trying to write to that table. And yes, that shouldn't happen, but it does, and the main reason is that the people who write forum software don't usually know much about SQL.
Of course deleting a user who is new and has only a few posts isn't going to make much of an impact, but when the user gets older and their postcount increases, it becomes more and more difficult to do it correctly.

For example, I ran into a problem where the "start of thread message pointer" was pointing to a wrong message in totally different thread because I had deleted the post AND the author of the thread. I needed to go into the db and fix things by hand, and it wasn't fun at all.
I never had it happen that someone would've replied to a message I was deleting and having it go haywire after the message replied to was no longer there, but the possibility is very much real and the consequences can be rather icky. (I suppose that that's at least one of the reasons why messages are not deleted but moved to "Trash Bin".)



posted on May, 10 2006 @ 03:58 PM
link   

Originally posted by Count

Originally posted by jsobecky
But of course I know nothing of what ATS is using, so all my observations may mean nothing.


You're quite well on track here, so don't feel that way


Thanks.


For example, I ran into a problem where the "start of thread message pointer" was pointing to a wrong message in totally different thread because I had deleted the post AND the author of the thread. I needed to go into the db and fix things by hand, and it wasn't fun at all.


Flinks and blinks (forward and backward links). My experience has been mainly on the hardware side (the guitar vs the music) but as you know nobody can be a true specialist these days. We had to become "system" specialists.

My son, OTOH, has seemed to have inherited the software gene.

When I look at some of the old programs that I was required to create as part of a class, they now look Greek to me.

Nice discussion, I appreciate it. And I always had respect for "beachball stackers", the software guys like you, even though most times I had no idea what you were saying.



posted on May, 10 2006 @ 05:52 PM
link   

Originally posted by SimonGray
The reason why accounts can not be removed, is that if an account is removed all posts that are associated with it will be removed as well.

This means that if someone who has started posts decides he/she wants his/her accounts removed, all those posts go along with it and all the replies.

In addition to causing a loss of information that users no longer can look, it could cause potential data corruption due to the sheer size of this website. We have seen the effect of data corruption when attempting to merge duplicate posts in the past, and let's just say it wasn't pretty!

How does this differ from deleting the posts/threads of a banned member? I can search Google at ATS for a couple known banned members (site member search results in only a name, and blank profile; which in itself is odd, as other banned members still have profiles), while the results show a post/thread, there is not a post by the user. Does deleting these posts not also cause a these problems?

NN



posted on May, 10 2006 @ 06:00 PM
link   
I think that members who've been banned and/or not asked for their account back in say a month, then their username should be free for a new member to use. Just an idea, because it seems that there's alot of banned members pointlessly hogging names. I suppose It doesn't matter all that much though, just a thought, but It seems to waste alot of space when your looking under "members"

[edit on 10-5-2006 by Xeros]



posted on May, 10 2006 @ 06:07 PM
link   
the only problem with that is if they've been banned, they may have made enemies. I'm sure new users wouldn't be too happy being branded before they begin.

[edit on 10-5-2006 by Rasobasi420]



posted on May, 10 2006 @ 06:14 PM
link   


the only problem with that is if they've been banned, they may have made enemies. I'm sure new users wouldn't be to happy being branded before they begin.


That's a very good point. I had'nt thought of that.



new topics

top topics



 
0
<< 1   >>

log in

join