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
community Data Science Portal alteryx .com community Data Science Portal alteryx .com community
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: 

Alteryx Connect Knowledge Base

Definitive answers from Connect experts.
It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!

File Size alert on Alteryx Connect after removing assets

conorbroderick
Alteryx
Alteryx
Created

on ‎02-07-2020 06:40 AM - edited on ‎02-27-2020 01:14 PM by Moderator

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 database H2 (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 the Horizon

 

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

 

Labels:
0 Likes