a new tool for those that want 2da data stored in mysql

[TormentedBlood]

one of the many INSANE things i have been doing that have kept me so quiet is that i am moving alot of the core functions into Sql calls with nwnx2 for nwn. i had a friend start a project to help me with this. it is a tool that parses a directory of .2da files and creates an sql script to place said data into a mysql database. http://kc5vzm.com/cms/blogs/view/post/6 his blog post is here. it is a java application. I am reworking aps calls to work with this structure. Most notably i am creating an indexed item database structure to help reduce the need of tons of palatized items, and it will allow things such as weapon models and colors that are available and even armor and body parts to be more easily tracked from in game solutions. Doing this mapping structure i have reduced lag delays from the mil body and mil clothing tailor scripts greatly. and i have been able to create sub-tables for each race and phenotype based on those annoying times when your custom clothing haks have a model for only one race and or phenotype etc. I am posting here for anyone that might find this useful. I will be putting my new core setup on the vault and posting links here soon.

[FunkySwerve]

Interesting. I'm a bit surprised that this cut runtimes, since all the speed tests I've done show that cached 2das outperform nwnx-mysql by a good margin. With the advent of the improved 2da cache, most 2das should be cached - unless the systems just use a ton?

Funky