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. "
