# Fix the size of config.idb **URL:** \ **Category:** Ignition\ **Tags:** ignition79\ **Created:** [December 13, 2020, 2:30pm UTC](https://forum.inductiveautomation.com/t/fix-the-size-of-config-idb/41478 "2020-12-13T14:30:21Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![guanghui](https://avatars.discourse-cdn.com/v4/letter/g/43a26b/32.png) [@guanghui](https://forum.inductiveautomation.com/u/guanghui)\ **Post date:** [December 13, 2020, 2:30pm UTC](https://forum.inductiveautomation.com/t/fix-the-size-of-config-idb/41478/1 "2020-12-13T14:30:21Z")
Hello, is the size (more than 1.27GB) of config.idb normal? I’m sure our project file is not that big 。 so I delete all datas from the table “project\_resources” in config.idb and import global and project backup,then the size looks as it should be. ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/0/1/01b93644fc7c0240d01c988dadf11f8b3c8ef3b9.png) ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/2/2/22d3b6b268918d2bb56bc3564c87034434ae0cc9.png) ![image|566x84] ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/4/8/483f65a3345a04b28642fe9e4e83af9dc6ab7e61.png) ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [December 13, 2020, 5:00pm UTC](https://forum.inductiveautomation.com/t/fix-the-size-of-config-idb/41478/2 "2020-12-13T17:00:13Z")
No, that would be unusually large. Long ago, with HSQLDB, there were problems with stale data accumulating. I haven’t seen that since the switch to SQLite. The other potential culprit is retaining many rows from SQL Bindings in component dataset properties. That usually results in slow window load times–a clue if that might have been your problem. ---
**Author:** ![guanghui](https://avatars.discourse-cdn.com/v4/letter/g/43a26b/32.png) [@guanghui](https://forum.inductiveautomation.com/u/guanghui)\ **Post date:** [December 14, 2020, 1:28am UTC](https://forum.inductiveautomation.com/t/fix-the-size-of-config-idb/41478/3 "2020-12-14T01:28:58Z")
One reason I can think is export and import the .proj backup from different ignition versions (7.9.12 & 7.9.14) to each other frequently. maybe this is an incorrect operation ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [December 14, 2020, 1:36am UTC](https://forum.inductiveautomation.com/t/fix-the-size-of-config-idb/41478/4 "2020-12-14T01:36:10Z")
> [@guanghui](#): > > maybe this is an incorrect operation Going backwards doesn't work out of the box, and hacking a newer project file to be accepted by an earlier version is prone to problems. ---
**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\ **Post date:** [December 14, 2020, 3:53pm UTC](https://forum.inductiveautomation.com/t/fix-the-size-of-config-idb/41478/5 "2020-12-14T15:53:38Z")
Also, 7.9 is prone to accumulation of data in the PROJECT\_CHANGES table, especially multiplied by the stale cached Vision data problem. ---
**Author:** ![isaias.berhe](https://avatars.discourse-cdn.com/v4/letter/i/e68b1a/32.png) [@isaias.berhe](https://forum.inductiveautomation.com/u/isaias.berhe)\ **Post date:** [May 26, 2021, 3:13pm UTC](https://forum.inductiveautomation.com/t/fix-the-size-of-config-idb/41478/6 "2021-05-26T15:13:35Z")
Is the problem with project\_changes table causing the idb size to grow to abnormally big size resolved yet? if not, is there a plan by IA to fix it? We recently had a prod issue because of this and we literally had to export each and every project, delete them and re-import them. In this case, i had the gwbk file reach over 1GB and we were able to reduce it to less than 300mb with this process. ---
**Author:** ![Kevin.Herron](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kevin.herron/32/7259_2.png) [@Kevin.Herron](https://forum.inductiveautomation.com/u/Kevin.Herron)\ **Post date:** [May 26, 2021, 3:14pm UTC](https://forum.inductiveautomation.com/t/fix-the-size-of-config-idb/41478/7 "2021-05-26T15:14:39Z")
It’s fixed in 8.0+ by virtue of projects not being stored in the internal DB… I don’t know if it will be, or can be, fixed in 7.9. ---
**Author:** ![isaias.berhe](https://avatars.discourse-cdn.com/v4/letter/i/e68b1a/32.png) [@isaias.berhe](https://forum.inductiveautomation.com/u/isaias.berhe)\ **Post date:** [May 26, 2021, 3:19pm UTC](https://forum.inductiveautomation.com/t/fix-the-size-of-config-idb/41478/8 "2021-05-26T15:19:18Z")
Thank you Kevin for the quick response. On high level, is there any major concern we need to be aware of in upgrading to 8.0+ from 7.9.14/7.9.17? fyi…Our projects are entirely in VISION and have not adopted perspective yet or plan to in the near future. ---
**Author:** ![Kevin.Herron](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kevin.herron/32/7259_2.png) [@Kevin.Herron](https://forum.inductiveautomation.com/u/Kevin.Herron)\ **Post date:** [May 26, 2021, 3:20pm UTC](https://forum.inductiveautomation.com/t/fix-the-size-of-config-idb/41478/9 "2021-05-26T15:20:26Z")
Staying on Vision is completely fine, but there are a long list of changes in the upgrade from 7.9 to 8.x that may or may not affect you. See [Ignition 8 Upgrade Guide - Ignition User Manual 8.1 - Ignition Documentation](https://docs.inductiveautomation.com/display/DOC81/Ignition+8+Upgrade+Guide) @nminchin also started documenting some things he encountered: [Undocumented changes when migrating from v7 to v8](http://forum.inductiveautomation.com/t/undocumented-changes-when-migrating-from-v7-to-v8/38044)