Hi,

I have problem with one table in my database.

I have server with 4 sites. Two small, two big with 20.000+ articles both. On one site I have Artio JomSEF. Everything is working good (SEO), but when the Artio JomSEF table jom_sefurls grow to 100+ MB (sometimes 495 MB+) server slow down. Sometimes I got message "Can't connect to MySQL server ", and everything is stop.

When I empty this table, everything is fast and good, but I have problem with finding urls. Visitors from Google,Yahoo,Bing... can't find articles. Artio Jom SEF send them to FRONT PAGE (I set this in administration to save visitors (404 message)). After some time Jom SEF index urls, and problem go away, but table jom_sefurls is to big, and server is slow!

Is there any solution for this? Stronger server, some settings on the server?

Please help me to sleep one night :(

Vladimir

Hi,
Try configuring caching in JoomSEF's Configuration (enable Professional mode first to see all options).
Also try enabling caching in Joomla and also the System - Cache plugin which caches whole pages.
If none of these help, maybe the stronger server will be needed.