Last post 3 hours 4 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.

#2888 – database and performance

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.

Wednesday, 26 October 2016 10:00 UTC

wortmann

Hi Yannick,

I have problems with the performance of my site. I asked Geraint from JEvents to have a look, because I have a lot of database entries with events from JEvents. Now he says sh404SEF could make the problems. He thinks its an issue with database table indexes not being optimal.

Is it possible to have a look to my site www.xxxx.de?
Of course:
- you get Joomla administration, FTP etc.
- if you need more time than for a normal support we can speak about the price of your support.

Thank you for your answer and your help.

Best regards
Jens.

Jens Wortmann
www.xxxx.de

Wednesday, 26 October 2016 10:39 UTC

wb_weeblr

He thinks its an issue with database table indexes not being optimal.

Nope, that's not the problem, indexes are pretty good after all those years.
Indeed, we do need to have one record (at least) in the database per each SEF/non-SEF URLs on the site. With events extension, this might be an issue, because they can create thousands, tens of thousands of URLs (links to each day, to next/prev weeks, months, etc. As search engines crawls and follow all those links, they will cause links for each and an everyday in the future and the past as long as they keep crawling the site.

This can end up making the DB huge, and possibly slow it down very much.

If this happens to you, maybe it's best to exclude JEvents from processing by sh404SEF. Go to the By components tab of sh404SEF configuration, and select "Use Joomla router" for Jevents (in the first drop down list).

Rgds

Thursday, 10 November 2016 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.