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

What type of URLs is mostly present in the table? Could you post some examples of SEF and Real URLs?

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

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.

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

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.