Menu Content

Support

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

Urgent need help issue with joomsef purchased
(1 viewing) (1) Guest
SEO component and search engine friendly URLs manager for Joomla!

If your topic falls within one of the subcategories, then please post it directly there. Post to this parent category only if your question does not match any subcategory topic.
  • Page:
  • 1

TOPIC: Urgent need help issue with joomsef purchased

Urgent need help issue with joomsef purchased 12 years, 6 months ago #24056

Hi we often use joomsef, but are having a particular problem with one site using a purchased version of Joomsef.

Do we need to purchase additional support for you to fix / take a look at this? We need this fixed at your earliest convenience and will purchase support if required as the site is mostly offline now, due to this problem.

The issue is as follows - if you contact me I will provide login details - thanks

My client received this email:

"With this notification we would like to inform you that your account
[domain-name] consumes a very high percentage of the server resources and
thus affects the performance of the whole shared server....

..etc

We have conducted a detailed investigation of the reasons for the high
resource consumption and it turned out that a script executes slow queries
towards its database, which eventually hogs the server.

..etc the problem is caused by slow queries executed towards
your application's database. There can be many reasons for slow database
queries, but the following 3 are the most common ones:

1. Large database
2. Not well written scripts
3. Large number of internal links that query the database directly.

Here are some of the database queries that are slow and consume a lot of
server resources:

Executed 11 min ago for 3 sec on Database --> [database-name].

SELECT * FROM jos_sefurls WHERE ((`sefurl` = 'contact.html') OR
(`sefurl` = 'contact.html/')) AND (`origurl` != '') AND (`trashed` = '0')
ORDER BY `priority` LIMIT 1

Executed 11 min ago for 2 sec on Database --> [database-name].

SELECT * FROM jos_sefurls WHERE ((`sefurl` = 'dvds.html') OR
(`sefurl` = 'dvds.html/')) AND (`origurl` != '') AND (`trashed` = '0') ORDER
BY `priority` LIMIT 1

Executed 9 min ago for 2 sec on Database --> [database-name].

SELECT * FROM jos_sefurls WHERE ((`sefurl` = 'advertise.html') OR
(`sefurl` = 'advertise.html/')) AND (`origurl` != '') AND (`trashed` = '0')
ORDER BY `priority` LIMIT 1

...etc etc

From the queries above we can conclude that your issue is caused by not well
written scripts. In order to have the limitations removed, you should
optimize your script so that it consumes less server resources.

...it would be best to contact the application's developers and ask
for further assistance. "
The topic has been locked.

Re: Urgent need help issue with joomsef purchased 12 years, 6 months ago #24100

Hi I can add that I believe that the problem is related to the number of sef urls being created in the jos_sefurls table as there are around 250, 000 urls - are you able to assist at all?

Maybe there is something we can change in configuration to help with this??

Thanks
The topic has been locked.
  • Page:
  • 1
User Login Empty