Item Hover / Average Prices
Filter
Show Official Posts OnlyReplies
Item Hovers The "average price" is something we've had trouble with for a long time and is something that is frequently incorrect on the item hovers because pulling up tons of data has been hard. So usually we pull up the last x (3-5) purchases and get the median from there, but that isn't very accurate when people undercut significantly (and then prices go back to normal) or people sell an item really high to move sP between friends.
So we've moved to a new system (a mongo database) specifically for item prices that should allow us to display far more accurate tool tips, as well as get things like the graphs in the item directory up and running again. This will also help with site speed because it removes a ton of data from our regular database (that isn't called up very often) allowing more important things to stay in memory.
The only problem is, it has to repopulate all of that data. So for the next few days items will be missing the "average price today". We're moving over a portion of our existing data and waiting for you guys to keep buying user shop items to help get the data up and running!
💖 ✨ 🤗
Thank you Keith! Man, you guys are just on a roll with these improvements. Keep up the good work, we appreciate it. x3
Wanna know more about battling? ❤️ The Official Battle Guide v3.3 ❤️ Need to find books? 🌈 The Book Grind Guide v1.0 🌈
Improvement in site speed? Just what I need! Thank you. :) [edit]Forum points!
awesome, thanks for this - I am sure this will make lives easier :D
Public Ping Group - Xanadu Galleria and RAE Collab
I really really extremely want:
Improved site speed AND more accurate item hovers? Awesome!
[tot=Gryphon]
Technical Explanation
In the past we've tried this by rolling our own mongodb system (you have to have multiple systems because mongodb has a failsafe) which is expensive, and I'm honestly not a system administrator well versed in running massive database systems. So in those cases, it didn't really work.
Now, we're using a database as a service (compose.io) to host this information. A service that is far better at running mongodb (its their job!) and can help support us in the case that we have a problem with our data.
We're looking at doing this for some of other "big data" type information which includes user logs. We're watching how this goes with the price information, which is a lot of information. When I flipped the switch this morning almost 8,000 price points were added immediately. We're up to 18,000 now about an hour later.
If it goes well, we'll extend it to logs which will make UAs helping a lot easier for most users.
💖 ✨ 🤗
Be interesting to see how it works, does this also mean that account worth (and wishlist sorting by price) will be less.. inaccurate ?
Yup! Account worth (and sorting by price, etc) is all tied to the same system, so after a few days it should be a lot more accurate.
💖 ✨ 🤗
thanks for the update :)
Excellent, I'm really looking forward to that. (especially the account worth)
Thank Jesus - Maybe now I can finally get the account worth achievements.
[Center][Url=https://www.youtube.com/user/ShutupandLetsPlay4]Shut up & Lets Play! Youtube Channel[/url][/center]
Sweet all around. XD Thank you!
[BR]'Cause I'm the big bad wolf,
[BR]now let the games begin!
Thanks for the update! 8)
Or it will show us just how far from it we actually were?
Oh, what an awesome update. Thank you for this.
