Show last update of item data

rubensayshi / gw2spidy

GW2Spidy - Guild Wars 2 Tradingpost Graphs

http://www.gw2spidy.com

231 stars 86 forks source link

Show last update of item data #100

Closed mercutiodesign closed 11 years ago

mercutiodesign commented 11 years ago

TODO:

[x] check if this is too performance intensive if you have a lot of buy / sell listings (I currently only have ~ 8 million in my db)
[x] display it in a nice way (maybe a column "Last updated / refreshed xx minutes ago")
[ ] maybe do something similar for recipes

In a perfect world where servers never crash one would probably not need this but in reality there can be technical issues so it would be nice to know if the price data is old.

rubensayshi commented 11 years ago

I added a seperate column for it because querying the listings table for that is suicide with 150mil records ;-)

https://github.com/rubensayshi/gw2spidy/commit/0964af37073c583ea8369983067ac4544837b8d8

mercutiodesign commented 11 years ago

That seems reasonable. The query was really fast on my little database but I thought it might look differently on your end.