Arrrrgggghhh!!!
Again! WTH. another 12,000 asset validation.
Grrrrr!!!
I did happen to notice that as the tadeamon was closing it announced that it was flushing the database. which really had me worried.
How often is this going to keep happening?
This is probably incorrect wording or maybe not. In database terms, a database is dumped when the application or server is closed.
Most databases today use what is called journaling and transaction files. All of the data stored is written to transaction files and the activity is stored in journals. Think of it as having a list and a box with stuff in it. When the program is closed, the data is moved to the database for final storage. The purpose of this is to prevent catastrophic damage to the information and to allow multiple actions to be completed at the same time. With the logging and transactions separate, it will help prevent data corruption should the database be open when there is a crash, or worse an unexpected system shutdown (crash). When the system comes back up, or the application starts again, the data is then "played back" and imported loaded to the last place you were prior to the crash. You may lose some latest transactions, but not everything is gone. In the old days, databases were open all the time so if you were to crash, you'd lose everything. This also allows for more efficient searching and data handling because the whole database isn't open for read or write. If the whole database has to open, then we'd have to wait forever for each transaction to complete before we could do something else. The way things are now, we can actually, within limits, search and download content at the same time.
So Content Manager's underlying utilities appear to work in this fashion using the SQL-Lite database engine. If you look at your Userdata folder while you are running Content Manager, you'll see .sql, .sql-wal, and .sql-shm files. To us they mean nothing, but to Content Manager, they are the temporary holding the information. Once you close Content Manager, TADDaemon does a bit of cleaning up and this data is flushed to its proper spots in Assets.tdx and these files are deleted.
I hope I explained this right!
John