How can I reduce the model size, The current model size is massive ( 23 G.B) and the run takes a long time. The model consists of 400 km of potable water networks
Hazem
Hello Hazem,
First, check if you have enabled Change Tracking. You will find it in Review menu. Click Change Tracking and see if the box is checked next to "Track Changes". If so, choose "view tracked changes" and check the number of records. If it is large (for example millions of rows), this can cause the database file to be very large and reduce performance especially when opening and saving the model. This could be caused by performing bulk operations such as ModelBuilder imports and constraint-based design runs. These types of operations can result in a large number of extra rows of data in the change-tracking system (sometimes tens of millions of rows). Please check the following wiki link for more details.
SQLITE database size grows very large due to Change Tracking
If you have made a large number of changes to your hydraulic model (and therefore its underlying database), portions of the database may become fragmented. Fragmentation can lead to issues where the database does not function optimally and over time this can cause performance issues or possible corruption. For this reason the software provides two ways to maintain the health of your project database files. The first is by automatic database compaction based on the number of times you open the database file via the File > Open function. The second is the manual option. The following article explains how to compact your model database in the OpenFlows products, to save space i.e. to reduce file size, increase speed, prevent possible corruption.
Compacting a database for optimal performance and general troubleshooting
If you are not satisfied with the answer. Kindly reply to this thread we will be happy to help you.
Answer Verified By: Ankit Kulkarni