I have split up my spells by era now, currently putting in Luclin spells. This is working very well and I have not seen any issues. Of course the export utility has to be modified to export the era of spells your server is currently on. I may change the way it is done but I am really thinking of sticking to one set of spells per expansion. There is really not that many spells per expansion and spells were constantly changing. My thinking is just a set of spells per expansion using a compound primary key.
Items are a different story though and I am still not happy with the items table. I wish there was a way to get full list of the items at certain eras. Unlike spells Lucy has no downloads for the items table. No API exist that I can find to download or query their database. Scraping the site would be painstaking the way the history page is for each item. It could be done but it would be horribly tedious to do.
|