Fast Load

One big problem with the first WorldWeaver client was load times. This was, in part, due to SQLITE opening and closing connections. Even when I modified it to keep the connection open for the duration of the client's execution it was slow.  This was tough to avoid, I really needed to run a query for nearly every game element.

In the new version of the client I need to get each element type from the database in a separate query, but  I'm doing it far more 'on demand'. Once elements are loaded they don't need to be reloaded of course but I load them as I need them. So far the load times are very fast.

I'm shifting some of the filtering work off to the client so I can cut down on the amount of queries to the database. And I'm using a single class with all the possible properties so that it is possible to walk up the parent chain and pass them around without the need to know what they are.

So far so good.