By Jordan Weinstein on Wednesday, 29 June 2022
Posted in General Issues
Replies 3
Likes 0
Views 575
Votes 0
Hello,

This table is occupying 1/2 of my database and is 100 mb in size: _social_urls

Is it necessary and any way to keep it smaller?
Hi Jordan,

That table is actually data from the SEF cache. You can purge the SEF cache here: ../administrator/index.php?option=com_easysocial&view=sefurls

This will clear out all the SEF data and let the system regenerate them back as users load the front-end. The advantage of doing is that you can remove old urls that no longer exist, thus reducing the size on the #__social_urls table.
·
Thursday, 30 June 2022 13:05
·
0 Likes
·
0 Votes
·
0 Comments
·
Tips if you are on new Joomla you can run a scheduled tasks to remove these built up sef urls regularly so you can sit calmly and drink beer instead of admin of Joomla/ES

more info here: https://magazine.joomla.org/all-issues/march-2022/get-to-know-the-new-joomla-task-scheduler
·
Thursday, 30 June 2022 20:06
·
0 Likes
·
0 Votes
·
0 Comments
·
Thanks for the tip ssnobben.
·
Friday, 01 July 2022 10:46
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post