Menu Content

Support

> Forums, FAQs & Paid Support
Welcome, Guest
Username Password: Remember me

Jos_sefurls table is huge slowing down site
(1 viewing) (1) Guest
Support forum for customers who have purchased JoomSEF 3 (Joomla 1.5 compatible). Archive only, no new post can be added.

NOTE: This category has been locked. If you have purchased paid version, please, use our Support Ticket system instead. If you are using free edition, please see the Community Support section.
  • Page:
  • 1

TOPIC: Jos_sefurls table is huge slowing down site

Jos_sefurls table is huge slowing down site 13 years, 3 months ago #23524

Every couple days i have to empty the jos_sefurls table because it brings our clients ecommerce site to a crawl. 10+ second page load times.

Why is this happening and how can it be fixed.

FYI: I am using the virtuemart module cherrypicker (this may or may not be relevant)

Order id: 00016730

Joomla version: 1.5.22

virtuemart version: 1.1.7

joomsef version: 3.8.1

virutemart extension version: 2.0.34
The topic has been locked.

Re: Jos_sefurls table is huge slowing down site 13 years, 1 month ago #24332

  • dajo
  • OFFLINE
  • Posts: 5069
What type of URLs is mostly present in the table? Could you post some examples of SEF and Real URLs?
ARTIO Support Team
The topic has been locked.

Re: Jos_sefurls table is huge slowing down site 12 years ago #34249

SELECT *
FROM `jos_sefurls`
WHERE `origurl` = 'index.php?option=com_sobi2&catid=17&lang=nl'
AND (`trashed` = '0')
LIMIT 2


How to clean up these queries? I got 700 of these when opening a page
The topic has been locked.

Re: Jos_sefurls table is huge slowing down site 12 years ago #34251

  • dajo
  • OFFLINE
  • Posts: 5069
Hi,
Unfortunately there's currently not much you could do about it. If it's possible for your website, try enabling the System - Cache plugin to cache whole pages.
ARTIO Support Team
The topic has been locked.

Re: Jos_sefurls table is huge slowing down site 12 years ago #34256

Are you kidding?

When I got SEF off I got only 46 queries. When joomSEF on I got 753 queries and slows down the website extreme.

What does this SELECTION say? even when I clean the table the problem exists.

SELECT *
FROM `jos_sefurls`
WHERE `origurl` = 'index.php?option=com_sobi2&catid=17&lang=nl'
AND (`trashed` = '0')
LIMIT 2
The topic has been locked.

Re: Jos_sefurls table is huge slowing down site 12 years ago #34285

  • dajo
  • OFFLINE
  • Posts: 5069
JoomSEF stores SEF URLs in database, so when the website is being loaded, it first tries to load each URL on the website from its cache and if it's not cached it tries to find it in the database. If you have many URLs on the website, this can result in many database queries.

However it would be strange if all the 753 queries contained the same `origurl` = 'index.php?option=com_sobi2&catid=17&lang=nl' part and you didn't have so many same URLs on your website displayed. In that case there would be either some problem in SOBI2 or in JoomSEF.
ARTIO Support Team
The topic has been locked.
  • Page:
  • 1
User Login Empty