#2565 – sh404sef_urls table is getting huge

Hi

Please tell me exactly which database table is getting huge. Is it #__sh404sef_urls, or #__sh404sef_urls_src?

Rgds

Hi

Hmm, if your server cannot cope with the number of URLs generated by the site, there are not really any good solutions. We can look at which extensions is generating that very large number of URLs, and disable sh404SEF for it, but the URLs are most likely going to change. That may not be a problem if those are "private" URLs, and it will be a problem if they are indexed by search engines.

Looking at the URL manager, I can guess it's JBusiness directory that's generating all those URLs. As mentioned above, to prevent most of the load, you can set JBusinessDirectory to "Use joomla router" in the "By components" tab of configuration. That should ease up the load on mysql, but the URLs will change.
If you go that route, and after setting JBusinessDirectrory to "Use joomla router", you can then delete URLs from JBD in the URL manager.

Note that to make the control panel more responsive, I have enabled the "Slow server" mode under the "Advanced" tab of sh404SEF configuration. You don't have as much information as when in regular mode, but display is faster.

Rgds

Hi

You can delete duplicates, but they will immediately come back. Duplicates are not created by sh404SEF, they are created by Joomla, and are stored when we see them.
That said, it can indeed give you some time. You cannot delete those URLs from the UI, at least not in a practical manners, but you can run a database query. You need to select and delete all URLs that have a `rank` field higher than 0.

Rgds