Sqlite Contortions

I finally bit the bullet and coded inheritance. It required a lot of database interactions. I had to retrieve numerous levels of nested elements, then insert new copies of them associated with the parent that inherited them. Many of these tasks had to be done within a loop, processing one object at a time. The result is painfully slow. Inheritance takes far more time than the rest of the game's compilation.

I may have to do contortions similar to those I did to speed up the rest of the compiling process. For that I gathered up all the SQL statements then called them all in large chunks so that there are only a few connection opens and closes.

I'm hoping I can build chunks of SQL strings for inheritance as well. I do my testing and developing on a USB stick so hopefully running on an actual harddrive will go faster as well.

On a side note, inheritance is working well. It doesn't support overriding yet, I may add that later. And sadly Commands (User input handling epements) stop processing when one is matched - at least with inherited items. I need to work this out. And would like to group connector objects at the end of each descriptive output.