why the change at the entered giveaways?it was way better the way it was.now it's harder to check a ga you entered 3-4 weeks before and way harder to check all your courent entered giveaway,for example i tend to leave a giveaway if the entries are way too many and now i have to check too many pages to view them.
Comment has been collapsed.
Kick all of them... Every single one of them...
Then invite them back because I love them all <3
Comment has been collapsed.
just a suggestion, but wouldn't it help to delete old threads/messages form discussions?
there are 82k uncategorized threads that are clogging up the database and are mostly useless.
it's just a matter of weighting options. what's more important, having 82k threads older than 1 year or a more responsive db?
Comment has been collapsed.
Sir, may I recommend some suggestions.
There are currently 104,761. I am betting over 95,000 of which probably hasn't been active in over a week, the majority of which probably months.
I would say that after a thread has gone 7 days without any input, have it automatically removed from the data base as it is old and ran it's course. That would probably recover a great deal of space.
Also, the same could be said for users records of previous wins and losses except have them go back and remove anything over a year old from the database. Keep the exact number of games accurate but you don't need to have a record of every auction they ever won, created or even lost.
So, just to sum it up.
1) Remove all threads inactive for more than 7 days.
2) Remove the actual lists of auctions won or created after 1 year while preserving the actual numbers.
3) Even though I did not mention this, but delete the records of all auctions over a year old as well as they are no longer needed.
Numbers 2 & 3, you could honestly move up to 6 months pretty safely. That would really cut the cruft off the database with little to no inconvenience to users unless they really like to look up on others to see every single individual giveaway they ever made or won since their account creation, which seems a little stalker-ish to me.
Edit: The threads hit 1 week old after only 5 pages. Everything older than that could very easily be deleted.
I have gone back up to 200 pages and still only at up to 20,000 threads of the over 100,000 posted. This is where the majority of your database has gone.
Comment has been collapsed.
The number of discussions is fairly small. The big tables are the giveaway entries (400 million), user games (100 million), and comments (40 million).
Comment has been collapsed.
For what we need who participated on any GA? I would make this:
Winners will be there forever and those that did not win, will be deleted from table after 6 months and just for statistics you can add new column to table with GAs "entries" so we can see how many entries, but will not see these people after 6 months.
400 million rows in table is too much.
Comment has been collapsed.
I know nothing about technical side of all this, but I will agree that keeping entries from 1 year ago is useless (when site doesn't calculate our estimated win chance). I'd like to know in how many GAs I already have participated (but I don't have to know in which ones exactly).
Comment has been collapsed.
Hi cg, please tell me you're not using the same database/server for the giveaway entries and the forums/comments O_O
I don't mind if you add more ads to the site if it helps to pay for another dedicated server for giveaways only. 400 million entries sounds like too much.
Comment has been collapsed.
Just a bug report- There are giveaways for games I already own showing up for me.
Comment has been collapsed.
Oh dear God, it just came back with 85 notifications. :P
Comment has been collapsed.
Oh, god, no... they are back XD
EDIT: gone again, phew...
Comment has been collapsed.
You can keep the notifications turned off forever, I kinda like it that way, but just give us the blacklist/whitelist feature you were talking about! Can't wait to see the numbers :D
Comment has been collapsed.
1,965 Comments - Last post 32 seconds ago by TwixClub
121 Comments - Last post 33 minutes ago by CutieTheRooster
16,414 Comments - Last post 48 minutes ago by Warriot
19 Comments - Last post 1 hour ago by Warriot
108 Comments - Last post 2 hours ago by LosingMyEdge
254 Comments - Last post 3 hours ago by IAMERROR404
796 Comments - Last post 5 hours ago by eeev
12 Comments - Last post 1 minute ago by eeev
38 Comments - Last post 1 minute ago by JMM72
25 Comments - Last post 2 minutes ago by FateOfOne
658 Comments - Last post 5 minutes ago by DrTenma
16,928 Comments - Last post 14 minutes ago by Drae
28,567 Comments - Last post 18 minutes ago by PsyKo
551 Comments - Last post 37 minutes ago by TricksterImp
I disabled message notifications in the top navigation bar for the moment. We're having some server issues as our database continues to grow in size rapidly, and this may help to reduce load time as I look into options available to us.
Comment has been collapsed.