Dear Customer

We use a SQLite3 database as a PowerScene file db backend.

The WAL (Write Ahead Log) is used in SQLite3.

When Powerscene write data to database, data will be written in the wal-file first before writing into original database file(.db).

When Check point reach, data in the WAL-file will apply to actual database and WAL file indicate to start location of wal file(The wal-file size will not be reduced ).

When powerscene app release database connections(may be close powerscene application), the the wal-file will be removed and data written in wal-file will be applied your database file(.db)

In normal condition, A checkpoint operation takes content from the WAL file and transfers it back into the original database file.

If other part of application read database for long time (powerscene access database concurrently), checkpoint operation will fail.

But presumably every read transaction will eventually end and the checkpointer will be able to continue.

If your wal-file is growing continually, It should be problem on powerscene app. So i want know 

1. which powerscene version do you use??

2. How big is your wal-file? (I think 10M size of will file is ok.) can you capture screen shot of your project folder??

If you are using old version of powerscene. please update with latest version.

Thanks

------------------------------------------------------------- 

Dear Anygate,

We have noticed that the {projectName}.db-wal file is growing in size uncontrollably, we have seen it reach 70x the size of the actual database file. What is the purpose of this file, why is it getting so large, and how can we prevent this?

Thank you,

RePurpose Energy