Trading history reset: Why?
There is no reset so that’s probably why.
They are limiting it to 90 days though.
I suspect that after 18 months of logging 3 million+ peoples very detailed transactions it has begun to strain their system and is causing lag on the TP.
Hate to ask but where is this information coming from? Didn’t see it in any of the announcements. Please don’t tell me Reddit strikes again.
RIP City of Heroes
maybe database or system issue. since saving huge amount of data will always have effect on system
Each transaction stores at the minimum, an id, account id, item id, quantity, price and date, which I’m guessing is 8,4-16,2,1,4,8 = 27-39 bytes + padding. Now imagine the hundreds of millions of transactions made since last year. Space really shouldn’t be an issue, but a database with billions of records would be, due to the lookup times.
Hate to ask but where is this information coming from? Didn’t see it in any of the announcements. Please don’t tell me Reddit strikes again.
It was hidden in https://www.guildwars2.com/en/news/new-finishers-back-items-and-more-in-the-gem-store/
It’s basically the calculation strain of looking up millions (billions?) of transactions, as Healix said. I was fully expecting this to happen at some point.
It is interesting to see some of the first items you ever bought though. Ectos were worth a lot cheaper then, as I used to buy them at 12s 83c each.
I wrote an app that tries to match the items that I am selling now with items that I bought so as to estimate how much profit I would make from the sale, if successful. Or how much profit/loss I would make if I re-list the item.
But as my past transactions lengthen, it keeps requesting for longer and longer listings until I decided to save my past transactions as a json file on my drive and merge the lists whenever I launch the app, so now it doesn’t need to request so far into my past transactions.
Now that their server would only keep up to 90 days of past transactions, what I did became even more useful as I would always have a record of all my past transactions to the release date because I have cached them on my drive.
(edited by DarkSpirit.7046)