well a month or so ago i had a duplicate video entry removed, but the video is still there, just not showing up in my profile/search. which is fine, but are those videos counted under the total video count? also wouldn't it be better for the database to remove the data not being accessed/used instead of just removing what links the video to a creator?
Pwolf
you don't actually "delete" the video from the dat
-
Pwolf
- Friendly Neighborhood Pwaffle
- Joined: Thu May 03, 2001 4:17 pm
- Location: Some where in California, I forgot :\
- Contact:
-
derobert
- Phantom of the .Org
- Joined: Wed Oct 24, 2001 8:35 am
- Location: Sterling, Virginia
- Contact:
Re: you don't actually "delete" the video from the
Not sure; they shouldn't be, but I'd have to check the code.Pwolf wrote:well a month or so ago i had a duplicate video entry removed, but the video is still there, just not showing up in my profile/search. which is fine, but are those videos counted under the total video count?
Actually, all that is changed is a flag. The extra few videos don't make for any significant amount of load on the db server, and this way if one gets deleted by mistake, we can undelete it.also wouldn't it be better for the database to remove the data not being accessed/used instead of just removing what links the video to a creator?
Key 55EA59FE; fingerprint = E501 CEE3 E030 2D48 D449 274C FB3F 88C2 55EA 59FE
A mighty order of ages is born anew. http://twitter.com/derobert
A mighty order of ages is born anew. http://twitter.com/derobert
-
Pwolf
- Friendly Neighborhood Pwaffle
- Joined: Thu May 03, 2001 4:17 pm
- Location: Some where in California, I forgot :\
- Contact:
Re: you don't actually "delete" the video from the
aye... i don't know how many people make the mistake and make a duplicate entry, i also don't know how much of a load the database puts on the server.derobert wrote:Not sure; they shouldn't be, but I'd have to check the code.Pwolf wrote:well a month or so ago i had a duplicate video entry removed, but the video is still there, just not showing up in my profile/search. which is fine, but are those videos counted under the total video count?Actually, all that is changed is a flag. The extra few videos don't make for any significant amount of load on the db server, and this way if one gets deleted by mistake, we can undelete it.also wouldn't it be better for the database to remove the data not being accessed/used instead of just removing what links the video to a creator?
but yea, the video is still there. I had used the link for the duplicate on my site and someone IM'd me asking me why it didn't have a local link... confused the shit out of me, until i compaired the vid id nimbers.
Pwolf