PHP-SQL script takes >9hrs to complete db

#1 - Oct. 7, 2014, 1:25 p.m.
Blizzard Post

This is the 2nd time I’ve tinkered with php-sql and I made a small script to retrieve the items and their sell/buy info into my db so I can sort/rank the items.

It works (yay!) but I feel its hugely inefficient because it takes like 9hours to completely copy TP info to my db is this normal? I don’t see where I can cut corners.

http://pastebin.com/JcZZZp98

oh i run it in the cli queued as a cronjob

#7 - Oct. 9, 2014, 11:31 a.m.
Blizzard Post

Or just using pagination + the Link headers we return (see https://tools.ietf.org/html/rfc5988 for a description)