This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.

Learn more
I AGREE
Reject

We have extended our Early Bird Tickets for Inspire 2023! Discounted pricing goes until February 24th. Save your spot!

community Data Science Portal Alteryx.com
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

Alteryx Connect Knowledge Base

Definitive answers from Connect experts.

File Size alert on Alteryx Connect after removing assets

conorbroderick
Alteryx
Alteryx
Created

‎02-07-2020 06:40 AM - edited ‎07-09-2021 04:39 PM

File Size alert on Alteryx Connect after removing assets

conorbroderick_2-1580231891574.png

  • The size of the database files depends on the activity made in the system. If you are removing assets from Connect using soft-delete (assets marked as deleted ) the database size is still increasing.
  • Synchronizing and adding more assets into Connect will also increase the size of the database.
  • Alteryx Connect uses databaseH2 (version .197) which does not support auto shrinking functionality so removing items from the trash will not shrink the database by itself.

What can I do to reduce the size of my database ?

  • Perform a Defrag
  • Perform a Compact
  • Set Soft-Delete to False

On theHorizon

  • In 2020.1 Alteryx Connect will be upgrading to H2 version .200 which will include auto shrinking functionality

Labels:
0 Likes