Database vs Internal storage

[Kanagaraj]

Hi Team, We have install Fisheye-Crucible 4.8 version in our servers. We have the data for the application stored in both local and external DB (MSSQL). Can you please let us know which data gets stored in local and which data gets stores in DB?

[Shawn Doyle - ReleaseTEAM]

Hi @Kanagaraj 

My experience is it's either or and not both.

If you see both, is it not stale data from before you added the external DB?

Here is a excerpt from the best practices doc if that may help. 

Do not use the built-in HSQLDB database for production use.

The Crucible built-in database, running HSQLDB is somewhat susceptible to data loss during system crashes. We recommend that you do not use HSQLDB for production systems. External databases are generally more resistant to data loss during a system crash and are more suited for production use.

To see a list of external databases that Crucible supports, see the Supported platforms page. For information on how to set up an external database, see the Crucible Database documentation.