| Pages: 1 [2] :: one page |
| Author |
Thread Statistics | Show CCP posts - 0 post(s) |
William Caldon
Caldari
Amarr Sisterhood of Galactic Sirens
   |
Posted - 2009.06.22 17:28:00 -
[31]
 Originally by: Kaylan Jahlar
Originally by: Grez
Inactive characters don't do anything but take up database space, which means nothing to the database. There would be no point in deleting them (in fact, it would produce more load). Separating them would just be complicated.
That is completely wrong.
Sorting, indexing, optimizing and backuping a table that has 4 million records versus one that has only 2 will take much less time. It would also take less time to search that table and thus reduce the CPU load of the SQL server indirectly.
The advantage of this change wouldn't be as much for the players than it would be for the db admins.
Please stop saying stuff like that when you don't have a clue when you're talking about.
Do you have any idea how CCP's database works?
Exactly, quit talking like you know what your talking about. |
Kaylan Jahlar
Minmatar Industrial Limited
|
Posted - 2009.06.22 17:55:00 -
[32]
Edited by: Kaylan Jahlar on 22/06/2009 17:56:52
Originally by: William Caldon
Originally by: Kaylan Jahlar
Originally by: Grez
Inactive characters don't do anything but take up database space, which means nothing to the database. There would be no point in deleting them (in fact, it would produce more load). Separating them would just be complicated.
That is completely wrong.
Sorting, indexing, optimizing and backuping a table that has 4 million records versus one that has only 2 will take much less time. It would also take less time to search that table and thus reduce the CPU load of the SQL server indirectly.
The advantage of this change wouldn't be as much for the players than it would be for the db admins.
Please stop saying stuff like that when you don't have a clue when you're talking about.
Do you have any idea how CCP's database works?
Yes I do know as a matter of fact. I know Microsoft SQL Server, which is what CCP uses (according to their data dumps), and I've seen data dumps, so I got a pretty good idea how their database and tables work too. Every SQL database works more or less the same. It's no different for theirs. It's common knowledge when you're a database administrator (which I am).
Besides, I don't need to know the details of how their tables are organised, named or what data goes in which table, etc... What I said applies to ANY SQL server environment. It's a known fact that a table that has more records will take more time to maintain, optimize, backup, index and search. It doesn't take a master's degree to understand that either. Everytime you do a search in a table, the server has to look through the index (if there's one) or all records individually. The more records you have, the longer this will take, so the more CPU it will take on the server. For example, depending on your backup system it could take hours just to backup a table with 4 million records, depending on the size of the records.
Now, I know that you can't just delete records from a relational database like this, because the character ID would probably be referenced in other tables at some point, so you would have to delete records in more than one table in order to do it without getting foreign key constraint errors. I don't know for a fact that it would be easily feasible for CCP to do this (it's always feasible, but not always easy is what I mean. Would need scripts and such), but I do know that deleting dead records from a database always helps. |
Syringe
Oedipus Complex
|
Posted - 2009.06.22 19:56:00 -
[33]
Originally by: Kaylan Jahlar
Blah Blah Blah!!! I've worked with MySQL, so I know how all of EVE works!!
QFT. Seriously. Having worked with MySQL and MS SQL (or hearing those words tossed around in a meeting, which is what I presume) does not give you anywhere near the full picture of what CCP is dealing with. What you're basically proposing is that "Hey, instead of ONE database, CCP should use TWO databases!!!"
That said - would YOU want to be the one to push the enter button after building that delete script on a production server of this size?
That'd be digitally akin to giving the order to drop the bomb on nagasaki. No thanks.
/not supported |
Grarr Dexx
Amarr
Corp 1 Allstars
|
Posted - 2009.06.22 20:04:00 -
[34]
NOT voted for. One of the key points of eve is that even when you leave for three years, you can come back to your account with everything in it. |
Darkwolf
The Older Gamers
Atlas Alliance
|
Posted - 2009.06.23 05:23:00 -
[35]
Originally by: Dapto
Also CCP you should look at wiping all inactive accounts that are over 3 years old. Do you honestly think these people will all of the sudden log in and pay-play again? its just more database clutter you can get rid of.
Actually, they do. I personally stopped playing EVE for over two years, and a year ago I just got up, re-opened both my accounts and have kept them going ever since.
I can tell you right now if I re-opened my accounts and they were gone, I would not have come back to EVE.
I support a flag that says something like "inactive" if the character hasn't logged in for six months or so. I do not support erasing of characters.
|
William Caldon
Caldari
Amarr Sisterhood of Galactic Sirens
|
Posted - 2009.06.23 05:42:00 -
[36]
I said CCP'S Database. Not a Microsoft SQL Server that you may/may have no used. I don't care if its the same, how its setup is more than likely different from anything you might have worked on.
Quit talking. Your not CCP's expert on their Hardware. Quit trying to make us believe that you know its a "simple fix" because it probably isn't.
This issue isn't that high-up there anyway. Please drop this already. |
Dapto
Minmatar
Dissolution Of Eternity
Event Horizon.
|
Posted - 2009.06.23 09:43:00 -
[37]
Actually William any SQL Data base administrator worth anything could do this is less than half a day. I wonÆt go into how I know and what I know as itÆs obvious you donÆt have a clue.
To the others re-cancelling or removing accounts I concede and I accept is a bad idea.
But I did like the flagging Idea.
You may ask why anyone would want this system?.
1: I keep all the names of those I've been at war with and the Corp they were in that war Dec'd our Corp/Alliance. I do know I'm not the only one who does this. You might ask why? ôKnowledge is powerö.
Eg: Joe blogs Corp war Dec's you and it lasts for however long thatÆs irrelevant. They go away then one day you get another war Dec from a different Corp but you receive Intel that Jimmy from Joe Blogs Corp is in this new Corp and you start the Intelligence process again. But this time you have a little advantage because you already have the Intel JimmyÆs joined the Corp so you check who from the previous Corp who has joined this new Corp. When you check the old Corp only 2-3 members remain and you rightfully or wrongly presume that most if not all have joined this new war decÆn Corp. You check your list and build the data base accordingly. The issue you have now is that this new Pirate/Merc Corp has a bigger membership of say 130 and the last war decÆn Corp had 75 but itÆs been 6 months since the first war Dec and most of that Corp joined them 4 months ago. The issue now is you have no idea whoÆs active whether youÆll be fighting a horde of 130 or what as half the 75 are now inactive.
Now you may say big deal itÆs no issue but when youÆre facing multiple war decÆs and the numbers are way over 200 your present Intel system of using your buddy list is useless. This is the issue if half of JimmyÆs Corp is inactive you donÆt know I doubt they even know. So it fills up your bud list with useless inaccurate Intel.
2: You got podded and you want revenge but you personally canÆt do anything about it because your new or cant PVP or whatever. So you go to a Merc Corp/Alliance and letÆs say you pay the 100mil up front and maybe 100mil for the Corpse. You inform them the isk will take you a few weeks to get as your trying to replace your lost ship too. They ask you can you use a Locator agent you say sure and that'll cost you possibly another 10mil. Now itÆs been weeks maybe months since this incident happened but youÆre still sore about it and want revenge so you do all this. The MercÆs do their job and have their people camping the system waiting for this dude to log on and undock. However this guys subscription has expired and youÆve just wasted 210mil.
With a flagging system at least you can find out if heÆs active and if so you could tie it in with locator agents so itÆs a service with a cost as this will reduce people from using and abusing it. |
Fumen
|
Posted - 2009.06.23 14:44:00 -
[38]
Originally by: Dapto
2: You got podded and you want revenge but you personally canÆt do anything about it because your new or cant PVP or whatever. So you go to a Merc Corp/Alliance and letÆs say you pay the 100mil up front and maybe 100mil for the Corpse. You inform them the isk will take you a few weeks to get as your trying to replace your lost ship too. They ask you can you use a Locator agent you say sure and that'll cost you possibly another 10mil. Now itÆs been weeks maybe months since this incident happened but youÆre still sore about it and want revenge so you do all this. The MercÆs do their job and have their people camping the system waiting for this dude to log on and undock. However this guys subscription has expired and youÆve just wasted 210mil.
With a flagging system at least you can find out if heÆs active and if so you could tie it in with locator agents so itÆs a service with a cost as this will reduce people from using and abusing it.
Guess if you had done your own intel before hiring the mercs, you'd have seen that this guy isn't active and not spent the 210 million to begin with. Or maybe you would have spent the ISK because the account just lapsed right in the middle of contract negotiations and nobody would have had had time to realize that the pilot wasn't going to play anymore instead of just being offline a few days. Oops. Guess that wasn't so helpful after all.
I would support 'inactive account' flagging only after X days/months of an inactive account (say 90 or 180 days). Too many people still make use of the 'ghost mechanics' for multiple accounts still.
|
Xenon Barinade
Caldari
Helix Protocol
|
Posted - 2009.07.04 07:48:00 -
[39]
Well it is the same as when you work, if you dont show up for work for over a month you can assume you have left, make a policy that pilots over X amount of time get kicked, simple and people will have to accept it :D
|
| |
|
| Pages: 1 [2] :: one page |
| First page | Previous page | Next page | Last page |