Newbie question about items.
Send a gazillion requests to the servers.
You can also download our database over here: http://de.gw2treasures.de/gw2treasures.sql.gz which is the backend of http://gw2treasures.de/
The backend of the backend is a slightly older version of my database repo over here: https://github.com/codemasher/gw2-database (haven’t done much commits recently because i’m waiting for the API v2. However, i’ll then try to keep the database itself as close as possible to the recent version)
(edited by smiley.1438)
So obviously it’s not going to be efficient pulling this data and then displaying it on a jQuery table, it’s probably easier if I pull it all into a database and feed the web service from there.
That link to your database file gives me a 404 by the way.
Hmm, ok, maybe Darthmaim took it down for whatever reason. I’ll make a dump of the current one and upload it to my webserver to save you the hassle of polling the API 4*~36000 times. Just gimme a little time.
€:
for some reason the export was interrupted at ~6.5k items <.<
I’ll tell Darthmaim to re-upload the DB to the above URL^^
€€:
He told me, that he’ll be home in 4-5h and upload it then. https://twitter.com/darth_maim/status/509313054115659776
(edited by smiley.1438)
Here is the new link for a snapshot of the item database behind gw2treasures: http://gw2treasures.de/2014-09-09_items.sql.gz
Sorry that it took me so long, i was at work.