|
|
|
|
|
|
|
|
|
|
Maintaining the files of Control Centers
When using a database, you may have to perform maintenance operations on the data files. These operations are used to optimize the access time to data or to free the locked transactions for example. When should these options be used?
When a technical problem occurs (power outage, etc.), when starting the Control Centers, a message can propose to cancel the locked transactions or to perform a re-index operation.
Note: If the Control Center database is large, regular reindexing is recommended. Caution: You cannot access data from the Control Centers during these operations. To start the maintenance of the files found in the Control Centers: - Select:
- in the Project Management Hub: Expand
 , then select "Maintenance". - in WINDEV, WEBDEV or WINDEV Mobile, go to the "Tools" tab, "Control Centers" group and select "Database maintenance".
- In the window that is displayed, specify:
- the relevant database.
- the operation to perform:
- Reindex database: recommended option for large databases
- Cancel blocked transactions: recommended option if a message indicates that transactions are locked when a Control Center is started.
- Migrate database to the latest format: recommended option to take advantage of all the new features of the current version.
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|