Last post 3 min ago

Posts last week 82

Average response time last week 34 min

All time posts 68082

All time tickets 10516

All time avg. posts per day 20

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.

#4342 – Huge database 2

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, 21 November 2017 16:32 UTC

nbussiere88

Hi there !

First ticket : #4291 – Huge database

I did some work and wanted to demonstrate that sh404SEF is taking of lot of time on the total page loading time. I know I need to find the component that creates that lot of URL -- over the years, I hate VirtueMart --, but with that many URL, it has a clear and documented impact on the total page loading time.

With a database with 176,000 SEF URL : the time to first byte is almost 6 seconds. Once all URL purged, the time to the first byte is less than 2 sec on all pages.

How can you explain that?

Best,

Tuesday, 21 November 2017 17:24 UTC

wb_weeblr

Hi

Only components doing nothing don't use any time on the page load. sh404SEF does things, and it uses the database, so it will affect the page load time. You need to have a MYSQL server and setup that suites your requirements in terms of DB use and number of users.

That said, your results are not consistent however. Purging URLs is the worst thing you can do, because it requires all URLs to created again, which is the most time consuming task of all. You should be faster with all URLs in the database than without them. Unless your MYSQL server runs out of RAM, or your hosting company cuts your resources on mysql, which is not uncommon.

176,000 URLs is quite average number, and should not cause any issue, even on a modest server. Actually, the number of URLs in the database has little effect on the page load speed. What matters most is how many URLS there are on each page. If you have a typical page with 200 links on it, then it will take much more time than on a page with less links (because it'll require more read on the database.)

Caching is the most obvious response to this type of issues, either module/content caching (Joomla configuration) or full page caching (Joomla cache system plugin)

Rgds

Tuesday, 21 November 2017 17:57 UTC

nbussiere88

Hi !

By the way, I am just searching how to solve the SLOW SERVER issue I experience for months now and I have only one clue : when I flush the sh404SEF database, the server becomes fast.

That said, I agree with what you say and I think the hosting company should help, which then don't unless I pay them. Screw them !

So thank you for helping me. Cache has been activated since 2 weeks, with no impact what so ever.

I will continue my journey.

Best,

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.