WAYYYY too many slow SQL queries, killing SQL server.

uninstalled

When this error happens?

Once pages are cached, users shouldn't notice much difference in load times.

Was your mysql server getting killed once you installed this on the forum linked to in your sig?

It doesn't matter at this point, I have no intention of reinstalling this mod.
Your mod caused hundreds of slow sql queries, which, of course, caused massive problems with the server.

So the SQL am i adding that to the current database that my forum uses?

the initial caching of a page is slow, we found 3 - 10 seconds. After that we found pages were generated almost as fast as standard pages eg; not noticeable when browsing.

You only have a hand full of posts. If it caused, as you put it "massive problems" i'd say you need to find a decent host or get a more powerful server. Maybe you could post some detail about the "massive problems" so dave or his off sider could comment?

It's not the host, or the server that is causing the problem, the mod is.
Stop trying to make assumptions about that which you know nothing of.

Prior to installing this mod, the forum used 1-5 mysql processes constantly. SINCE using the mod (before removing it), the forum jumped from 1-5 mysql processes constantly to 50-70. There is no reason for this except the mod. Once the mod was disabled and removed? Back to 1-5 mysql processes.

This mod handles sql VERY poorly and causes issues. It's not the server's fault the mod is slow, it's the mod's fault. It's not the server's fault the mod handles queries slowly, it's the mod's fault. It's not the server's fault the mod takes forever to work, it's the mod's fault.

Stop trying to blame things which you know nothing of. The server wasn't under load at all, in fact, it was just fine. The mod makes entirely too many slow queries, end of story.

I've installed this on 3 forums so far, one has 7 million+ posts, the other 3.5million and the smallest 1.1 million. 1,500+ active user sessions are common on all of them.

MySQL usage obversely increased, there were no noticeable effects on server performance from a users POV. Average load floats between 1 and 2 on all of our servers, none of them have "massive problems".

You have 2,300 posts in the forum linked in your sig. You must be able to see why I suggested server or host maybe not up to scratch. You inital post was vauge so I went for the low fruit ;)

The mod isn't perfect, but it does a reasonable job. It's very easy to install and once translated pages are cached, they load fast enough for a user not to notice a speed difference between translated and non-translated pages.

regards

One of our forum members has a lot of experience in this area. I will ask for his suggestions and get back to you on this.

As for Japanese, so far we have found the Yahoo translation service much better than Google's service. However, I have no idea about the API service.

Wen i use Save the plugin and activate.