Personal tools
You are here: Home Community Blog It matters where you save simulation results

It matters where you save simulation results

Gain performance by exchanging the DB back-end.

I installed PillarOne.RiskAnalytics v0.4.2 on my laptop and played with the PODRA model. Where do my simulation results get saved? I wasn't asked to set-up a DB during the installation of the software.

If you install PillarOne.RiskAnalytics as a stand-alone software, then it uses a light-weight database product called Derby. That's great because the RiskAnalytics installer knows how to configure the derby DB.

But a light-weight product like Derby does not offer the same performance as a comprehensive DB product. In addition, access control and logging are not available. Hence, for operational use we recommend using a product like MySQL, ORACLE, DB2, SQL server, etc.

Until now, that was the end for me - I don't know anything about setting up one of these products. Stefan's How-to has only 7 steps (and he even counted logging in to the DB server as one ;-).

<15 minutes later>

I still don't quite understand what I had to do with the DB. Who cares, it works!

Now my poor old laptop will get some real simulation load.

-- Markus

PS: It pays to have a clean architecture: I only had to edit one line in a config file.

Document Actions