Architect Archive
Thread: Solve the Storage issue in One Publish
Page 2 of 2
WhiteRose555
Sat Mar 27, 2004 4:41 am
#14
Let me start off by saying I am a Database Administrator in the real world and deal with database issues and performace for a living.
Biggest Cop Out: The database is too big!
So why not do things to reduce the database with out making it the players problem that your design does not scale? When did the database become our problem and that we should be punished for it? I pay my monthly fee every month, on several accounts actually. Where that money going?
There are tons of technical solutions for handling large databases.
1) Add bigger better servers.
2) Break up your databases into more databases and host them on more servers.
There is no one game server cluster that stores more than the IRS or Mc Donald's Sales Databases.
When the last time you heard, "You do not have to pay taxes this year, we can not store it?" Or "I am sorry you can not order a Big Mac our sales database is to large to record your sale?"
I love playing this game and I have multiple accounts with mostly crafting professions.
IMHO These are the easiest things to change to get the quickest return on database performance as wel as server performance.
1) Increase stack and crate sizes - One record with a quanity of 25 will always be less that 25 individual rows in a database.
2) Increase storage limits or remove them. Why are they really there? Simple to get people to buy more accounts. How do people get around the limits. a) Buy more accounts b) Sever swapping and Lot Trading c) Place 3 med instead of a large house. When you do method c it just add the lag issue and places more structures on the landscape.
3) Remove canceled accout'sstructures,harvsters and items. (Shudders pretty sure some of hisharvesters would be gone) Why does SWG not remove these items?..Simple it is easier to get some one who let there account lapse to renew if they do not have to start over. They are not paying or playing any more, why is my game expereince being impacted by them (ie database too big).
4) Remove all illegal vendors - This is a hot spot on the merchant forums. But taking the merchant line, placing vendors dropping all the skills increase the number of vendors and items sold. This is an exploit why is it allowed to go on? I drop pistoler I do not get to keep my dx2 certification or medic I can not use stims anymore. Simple math says less vendors lessitems stocked, craftedand sold. You can argue that they would just have there freind merchant sell them for them. Some of that would happen and would actually be a good thing for the merchant profession. But anyone who manges a large number of vendors with high item counts can tell you there is such thing as critical mass. Who want to spend all there game time putting 5000 items back up because someone else doesn't want to invest the skill points or time?
Annon
Chilastra
Indene
Sat Mar 27, 2004 7:40 pm
#15
lees wrote:
1. Increase resource stacks to a maximum capacity of 1,000,000 units.
2. Increase crate capacity for any object to a maximum of 1000.h*ll yes i like this.
The DEV's should run a DB check and see how many horded resources are in 5+ 100k lots. I know I have several myself. If they did this I bet there would be a dramatic change in the DB. However it is also true that for many accounts the limit is the storage slot and if I could put those 5 100k blocks in 1 slot then I have 4 slots I can now fill with other stuff. Hmmm... Not as much help as we hoped. However on vendors it would help because I can already just keep placing 100k blocks till.....
Oh and please make it so a user can select the number of units in the purchase. That would remove millions of db entries for all the millions of 1k blocks of identical ressources that we place because our customers dont want to buy 100k of a resource when they only need 100.
-Indene-
justapilgrim
Sat Mar 27, 2004 7:45 pm
#16
like some of you have said, ther eare easier ways of doing this my 2 favorites:
increasing stacks of resources to 1 million units
increasing the size of crates to 1000 across the board, no more crates of 25, 50 or 100, an entire factory run in only one crate
SkinnyManDo
(battlemaster turned wussy crafter)
(battlemaster turned wussy crafter)
Master Armorsmith, VALCYN
Page 2 of 2