Development Cycle Archive
Thread: In-Concept Open Discussion (Week Ending 3-22-04)
SpeerRedow wrote:
Ideas to improve server latency and to ease database usage/storage:
1) There have been many ideas to raise the stack values on crates and stackable items such as resources. This can help with database issues, for example: lets say you have 1000 units of item X in one or more crates. If the max stack is 1000, you have 1 entry in the database for it, with all its attributes. If max size is 40, you now have 25 entries for what could be considered the same exact thing. That repeats the same attributes (stats, names, locations, etc) 25 times. Doesn't that waste storage? Access time? Although this is a very small example, if extrapolated to all the servers and tested, I would think there would be a lot of memory saved.
How about allowing things like loot items stack? I have 9 identical krayt tissues, but instead of one stack of 9, I have 9 individual items.
lund0529 wrote:
SpeerRedow wrote:
Ideas to improve server latency and to ease database usage/storage:
1) There have been many ideas to raise the stack values on crates and stackable items such as resources. This can help with database issues, for example: lets say you have 1000 units of item X in one or more crates. If the max stack is 1000, you have 1 entry in the database for it, with all its attributes. If max size is 40, you now have 25 entries for what could be considered the same exact thing. That repeats the same attributes (stats, names, locations, etc) 25 times. Doesn't that waste storage? Access time? Although this is a very small example, if extrapolated to all the servers and tested, I would think there would be a lot of memory saved.
How about allowing things like loot items stack? I have 9 identical krayt tissues, but instead of one stack of 9, I have 9 individual items.
Now if only a Dev would tell us if this is possible, feasible, and would help server/database performance
Please fix heavy weapons SEA as they currently do not work on either the LLC for bounty hunters or any of the heavy weapons for commando.
TH: has there been any word on fixing the Debris Piles so that they can only be looted by someone who is actually playing the game? IE: Borgle Bat Cave on Rori. Same thing every day, everyone and their brother circling around the piles with an AFK macro program running.
Crystals from the source...?
It seems to me that force crystals shouldn't be loot only items. Why is it that you can find them on a low-level thug, but not in the ground? If you added items as random sample events, you could allow for Jedi to get crystals without having to kill thousands of NPCs to get one.
You could also put things in there that are just random finds, artifacts, just anything that might be buried. Maybe a crystal is more likely to be found when sampling gemstones? I can snag items fishing, why not find them while sampling or maybe foraging?
This would also cut down on kill-stealing and camping of static NPC spawns in cities too.
Pearls could go the same way... maybe only on Tat? Maybe only near the krayt graveyard? With all those bones, there must be a pearl or two out there in the sand...
AFK Dancer/Musician fix:
have a pop-up like surveying (the afk sample fix). Make the text what you wish but give an option; 1) ignore and continue dancing/playing music, 2) attempt feat. If option 2 is chosen there is an XP bonus involved.
Please fix the Combat Medic exploit of having a range of 80meters.
Please fix exploits regarding base destruction and timer reset.
Please fix clone/full stomach issue.
Thank you.