It’s been a packed couple of months for me. Both in terms of RL work and also completely rewriting some of the back end application. As many of you who use the projects feature have found, it can, in complex projects such as capitals, become annoyingly slow. In some cases taking minutes to open projects. The reason for this were obviously unoptimized sql queries and as I found out, running the same query multiple times to get the same result or a result that could just as easily be attained with a little logic. So a massive rewrite of the back end logic was done and now the barest number of SQL queries are ran and some of the higher and longer running algorythyms have been passed from the backend to the client to run. The new structure now only opens a bare framework and I’ve passed most of the project logic and project HTML rendering to the client freeing up quite a lot of server resources.

The Eve market relay consumer has also had a complete rework. As it turns out, it was hammering the database pretty much constantly also causing the general slowness of the site. The new method has reduced the number of queries ran for the EMDR consumer from thousands per minute to about 10 per minute. On my virtual machine test environment the difference is very noticeable.

Please note though that this is not a fix everything that was broken on projects. This was a rewrite of what is currently there to optimize and speed things up but to sweeten things I have added a couple of toys. I’ve done away with the drop down option in favor of clickable item names and results being displayed in a moodal manufacturing calculator window. I feel this gives a better understanding and scalability for macro management and project planning.

Assigning resources from assets is still none functional for the moment but that will be changed very soon now that I’ve reached a stable release candidate. While I have attempted to make sure everything that worked in the old project system was carried forward to the new, there may still be some bugs to find and track down so please bring them to my attention via ingame message, the site feedback tool or reply here on this post and I’ll get them patched as soon as I humanly can.