right now, it often times out and crashes, with mean response times of 22 seconds, which is totally unacceptable. it might even be the major cause of site outages at this point - hiscores seem to be much more stable lately.
current behavior:
user visits page
perform an API query on osbuddy prices (deprecated, slow service) <-- root issue
update items table with new prices
query items table
render in page
desired behavior:
run a scheduled task to update item prices
user visits page
query items table
render in page
also, might as well add a few more items and stuff while we're at it
right now, it often times out and crashes, with mean response times of 22 seconds, which is totally unacceptable. it might even be the major cause of site outages at this point - hiscores seem to be much more stable lately.
current behavior:
itemstable with new pricesitemstabledesired behavior:
itemstablealso, might as well add a few more items and stuff while we're at it