Is it safe to clear the sys_tiny_url table?

AfshinNia
Tera Contributor

The sys_tiny_url table on our instance is very large.

We see there are some entries whose "Last Accessed" value is more than a year old.

Reading on the purpose of sys_tiny_url it seems like its something that can be generated or cached on demand.

Is it safe to clear the data in the sys_tiny_url table?

Thanks

1 REPLY 1

Thameem Ansari
Giga Guru
Giga Guru

Hi AfshinNia.

Yes, it is safe to clear the sys_tiny_url table.  Basically, a record will be inserted into this table when the user builds a query in the list view which is too large to show in the URL.

for example, May have 1000 incident numbers with him and only want to view those in ListView. So he will build a query as shown in the image below

find_real_file.png

once he executes the filter as the query size is very high. the system will create a tiny URL record 

and will show the URL as below

find_real_file.png

It will become very helpful when you need to execute the same query in the Background script for any other purpose. instead of adding all the incident numbers in the background script manually, we can make use of this tiny URL . so our code will be less complex

Just to be on the safe side. First, try clearing the records which are not been accessed for a long time. That probably means that the query was used only for the time thing. 

 

Also additionally you can configure this table for AutoFlush using Table Cleanup to automatically purge the record based on the configuration so that you don't need to worry about it again. 

 

Please mark it as helpful If my answer is helpful in any way, 

Best regards,

Thameem