I love the tags! Thank you <3

Link: https://www.sylestia.com/forums/?thread=63707&page=3#28 Author: Varyntha Time Posted: 7/15/2018 at 2:42 PM *runs around flailing tentacles* Wonderful, super awesome! ^D^ Simply out of curiosity because I know so little about coding and computer processing, why is it more of a strain to do ascending versus descending? :o (The only theory I could come up with with my limited knowledge seems pretty flimsy...)

The real answer was about 2 hours of me scouring dozens of articles and posts on the internet. Lol.

But the short version is, basically:

Our pet tables use innodb instead of myisam, as they should for such super high traffic tables w/ 4+ million entries. Myisam uses full table locks on every single update/insert. This causes massive backups and lag. Innodb uses row-specific locks which makes things flow much easier.

Unfortunately, myisam is better at record keeping on a table-scale level than innodb. For large search results (since I removed restrictions and you can literally get up to 4 million results), I have to sort the results via the query itself and not via the PHP script. Past like 5-10k results, PHP begins to take a really long time to sort through that much data.

So the script kinda uses some logic and stuffs when you submit your query and tries to figure out the best way to sort the data. Most of the time though, it's sorted directly in the query.

Back to innodb... innodb is bad at full table sorting b/c it basically has to go through the entire table to sort whereas myisam keeps specific sortable data separate for quick/easy access. And from what I could gather, it favors a last in first out process (aka, descending). So sorting by descending is much quicker for innodb to do. Sorting by ascending requires it to actually sit there and sort through all 4+ million entries each time and scan the whole table.

So - that's my best explanation as to why. At least what I was able to gather from hours of researching. And my results confirmed. In tests, sorting by any of the other values asc/desc or by id desc were fast - sorting complicated queries by id asc were 10-100x slower. So I just made the default id desc to help lighten the load b/c whatever the default is will be what the majority of the searches will be.

@Savynn,

If these are ones that are tagged on the profile page as "This pet can have its Themed regen'd" or whatever that message is, then yes.

But if they are just sneaky hidden differences, I would have no real way of knowing the difference on such a large scale.

Link: https://www.sylestia.com/forums/?thread=63707&page=2#15 Author: Xavion Time Posted: 7/15/2018 at 10:00 AM Roasted Chestnut for the example?! I am honored; thanks Krin! ^__^ There are a few things that call my attention though. Since I base my projects on themed pets and dye them from there, it is pretty funny seeing my altered pets still tagged as a purebred theme. The offspring from the dyed pairs don't even carry the dye markers, and on regens there's nothing marked at all for the alterations. Offspring of dyed, regenned Ny'vene, dyed Griffi All still tagged as purebred. Small matter, but for people not familiar with themes it may end up being misleading. ^^;

With what's available to me and how things are presently set up, it'd be quite a bit of work to create a system that monitors and clearly displays all of this information.

So I kind of view it as those who dye actual Themed Pets - they are still considered valid Themed Pets even if a player decides to dye them.

Also, once a regen takes place, that information is not logged. I have no way of knowing which pets have been regenerated once they've been regenerated. So there's that issue as well.


I am sure in the future when things are revamped, things will be very well documented and things like this can be built in and whatnot. But at this time, there really isn't much I could feasibly do.

Link: https://www.sylestia.com/forums/?thread=63707&page=2#17 Author: Kaydra Time Posted: 7/15/2018 at 11:01 AM Would it ever be possible to show the stars on pets in our stables as it shows on their lineage to make it easier to sort our tagged and purebred pets?

With how the Stables currently are, I'm not sure there's really anywhere to stick it that wouldn't just be kind of obnoxiously placed. But it could be something I keep in mind for the future.

Oooooh, I see! ^o^ That's all very fascinating! ^D^ (At least to me as a person that didn't already know all of that. xD ) Thank you so much for explaining it! ^D^

Oh this is GREAT! Thank you!

Oh this is perfect Thank you for this update

Alas they're sneaky changes. It seems like they mostly all take place in 2015. Here's the guide I was working on before. There is I think one qitari theme missing. I'll have to double check. Also, not really sure if the reindeer qitari were really ever changed. Most of these were ones I compared using at the minimum epics of each to try to get a better idea of accuracy. Some are much more obvious than others.

https://www.sylestia.com/forums/?thread=25437

So if these were to be changed, I guess it would be dependent on payer reports and then carefully comparing the colors of ones with more trait points to see if there's really something to it.

Edit: realized the reindeer qitari don't really make a difference cause if there was a change it was away from the 2012 pre-tagged version.

Thanks for posting the thread on color changes! I have been looking for something like that, Savynn! Thanks as well for all the work you put into it!