Last post 4 hours 5 min ago

Posts last week 141

Average response time last week 4 hours 42 min

All time posts 67801

All time tickets 10476

All time avg. posts per day 21

Helpdesk is open from Monday through Friday CET

Please create an (free) account to post any question in the support area.

Please check the development versions area. Look at the changelog, maybe your specific problem has been resolved already!

All tickets are private and they cannot be viewed by anyone. We have made public only a few tickets that we found helpful, after removing private information from them.

#6854 – Slow query

Posted in ‘sh404SEF’

This is a public ticket. Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.

Tuesday, 07 January 2020 06:57 UTC

sergio0187

Hi,

My server is slowing down so I'm looking at slow queries. One of them is found in SH404SEF, please find it below:

SELECT `oldurl`, `newurl`, `id`, `rank`, `dateadd`, soundex(`oldurl`) AS soundex_value FROM `j25_sh404sef_urls` where `newurl` <> "" and `rank` = 0 AND `oldurl` not like '%vmchk%' AND `newurl` not like '%format=feed%' AND `newurl` not like '%format=pdf%' AND `newurl` not like '%print=1%' AND `oldurl` not like '%\_\_404\_\_%' AND ( soundex(oldurl) = soundex('over-ons/algemeen/ervaringen/stilteretraite') OR `oldurl` like '%over%' OR `oldurl` like '%ons%' OR `oldurl` like '%algemeen%' OR `oldurl` like '%ervaringen%' OR `oldurl` like '%stilteretraite%') GROUP BY `oldurl` limit 500

Is there anyway we can improve this query?

Thank you in advance.

Kind regards,
Sergio Wong Chung

Tuesday, 07 January 2020 07:19 UTC

wb_weeblr

Hi

This is the query ran when a 404 happens and sh404SEF searches for "similar URLs" that can be suggested to the visitors. You can:

- regularly purge the 404 error logs as they are part of the SQL queries
- or you can disable this feature by disabling the "Similar URLs" plugin from Joomla plugin manager. When you do that, you'll need to adjust the text of your 404 error page from sh404SEF configuration, under "Error page" to remove the reference to similar URLs.

Best regards

Wednesday, 22 January 2020 05:34 UTC

system

This ticket has been automatically closed. All tickets which have been inactive for a long time are automatically closed. If you believe that this ticket was closed in error, please contact us.

This ticket is closed, therefore read-only. You can no longer reply to it. If you need to provide more information, please open a new ticket and mention this ticket's number.