I fixed this on my own and figured I post my results here:

In my case I have a very large website with over 10,000 pages and over 100,000 links ion the database. When you clicked on any link form the hom e page the site would hang. I noticed that the site was running a lot of queries that seemed to hang the whole site. In looking further into the database I noticed that the column that is primarily used for these queries was the "oldurl" which was not indexed. I added an index to that column and now my site is up and 10xs faster than it was before.

Hopefully this will be changed in the next release of the ArtioSEF Component.

Rob Out!

I am having this same problem on a website that was working perfecty fine until this morning. Now only the home page loads and all sub pages do not. They just hang and time out. The MySQL database is running hot but should not be effecting the site since other websites on the same server (also running Joomla) are noot having the same problewm. It seems to be isolated to the one websiete

I need help fast and ASAP for fixing this. I can not post the site or any sensitive information here, but can be reached directly ausing Diese E-Mail-Adresse ist gegen Spambots geschützt! Du musst JavaScript aktivieren, damit Du sie sehen kannst.

Please contact me if you know what might be wrwrong. I can fin pay for the time too.