# Image Management Tool: Size Limit?

**URL:** <https://forum.inductiveautomation.com/t/image-management-tool-size-limit/39026>\
**Category:** Ignition\
**Created:** [September 24, 2020, 3:04pm UTC](https://forum.inductiveautomation.com/t/image-management-tool-size-limit/39026 "2020-09-24T15:04:53Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![dkhayes117](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/dkhayes117/32/68344_2.png) [@dkhayes117](https://forum.inductiveautomation.com/u/dkhayes117)\
**Post date:** [September 24, 2020, 3:04pm UTC](https://forum.inductiveautomation.com/t/image-management-tool-size-limit/39026/1 "2020-09-24T15:04:53Z")

</div>

I’m trying to upload images from a local folder into the image manager, and it is taking longer and longer for them to load. Now I can’t even open the file I loaded them into, it just locks up. Does the image manager have any limits? If I use one of the images inside the folder by using its path, it loads into a component just fine. I just can’t open the folder in the management tool to view or add to it.

v7.9

---

<div class="post-metadata">

**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:** [September 24, 2020, 3:35pm UTC](https://forum.inductiveautomation.com/t/image-management-tool-size-limit/39026/2 "2020-09-24T15:35:39Z")

</div>

There’s no explicit size limit, _but_ images are stored inside the internal DB, in a single (possibly unindexed, I’d have to check) table. Also, on 7.9, you’re fighting with project resources and project changes inside the same IDB. If you get in contact with support (or are reasonably comfortable on the command line) you can use the sqlite tools ([https://www.sqlite.org/download.html](https://www.sqlite.org/download.html)) to run an info dump on your `config.idb` to see what is taking up the most space inside the file.

---

<div class="post-metadata">

**Author:** ![dkhayes117](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/dkhayes117/32/68344_2.png) [@dkhayes117](https://forum.inductiveautomation.com/u/dkhayes117)\
**Post date:** [September 24, 2020, 5:02pm UTC](https://forum.inductiveautomation.com/t/image-management-tool-size-limit/39026/3 "2020-09-24T17:02:46Z")

</div>

It was perfectly fine until I started adding pictures to a new folder. I have added about 4,000 photos at an average of 30kb each.

---

<div class="post-metadata">

**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:** [September 24, 2020, 5:41pm UTC](https://forum.inductiveautomation.com/t/image-management-tool-size-limit/39026/4 "2020-09-24T17:41:33Z")

</div>

Are they in a flat structure, or deeply nested in folders? You could try manually adding an index to the table; something like:  
`CREATE UNIQUE INDEX idx_image_path ON images (path)`

---

<div class="post-metadata">

**Author:** ![dkhayes117](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/dkhayes117/32/68344_2.png) [@dkhayes117](https://forum.inductiveautomation.com/u/dkhayes117)\
**Post date:** [September 24, 2020, 6:59pm UTC](https://forum.inductiveautomation.com/t/image-management-tool-size-limit/39026/5 "2020-09-24T18:59:20Z")

</div>

I’ve got sqlite3 running, but I don’t understand how to connect to Ignition internal db. I ran `.databases` command and it returned _main:_

---

<div class="post-metadata">

**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:** [September 24, 2020, 7:00pm UTC](https://forum.inductiveautomation.com/t/image-management-tool-size-limit/39026/6 "2020-09-24T19:00:18Z")

</div>

In command/terminal/etc, you should just run `sqlite3 path/to/config.idb` or `sqlite3.exe path\to\config.idb` if Windows. Do _not_ do it while your gateway is running!
