Sparx Systems Forum
Pro Cloud Server / Prolaborate / WebEA => PCS Frequently Asked Questions => Topic started by: ea0522 on October 17, 2023, 04:49:37 pm
-
We have a PCS environment using a QEA file on the server to store our repository.
This works fine, I just have some questions regarding the journal file created.
What is the algorithm to commit the journal information into the QEA file?
How long will it take for the background proces to do the commit?
Can I force a commit?
Is there a limitation on the direct use of the QEA file while there is still a journal file present?
For instance, can I copy the QEA file for backup or use elsewhere without copying the journal file?
I have a PowerBI connection using the QEA file directly as a source for data.
Can I just use that connection even when the journal file is still present or do I have to wait for the data to be committed?
Just some questions.
-
I'm just wondering, what made you choose a QEA file as database on the server?
Looks like a lot of problems or questions you are having wouldn't be an issue if you used a server-based database such as MS SQL Server or MySQL
Geert
-
Every thing has its pros and cons as a famous soccer player once said ;-)
In our case, the QEA file is the most easy to set up and maintain. Too much of a hassle (and costs) to set up a SQL server.
-
Too much of a hassle (and costs) to set up a SQL server.
I'm not sure if you aren't choosing for the cheap option now, that will end up much more hassle and costly in the end.
Inspiration: https://dba.stackexchange.com/questions/21/is-it-possible-to-use-sqlite-as-a-client-server-database (https://dba.stackexchange.com/questions/21/is-it-possible-to-use-sqlite-as-a-client-server-database)
Geert