[NeutralizeR]

Originally Posted by imported_silkroad

This plugin is a performance killer on a site with many Google keywords searches. We get over 600,000 Google searches each month. This mod just kills our SQL database performance unless we constantly trim the tables.

Can the developer fix this?

Perhaps offering an option to trim the table after it grows to some number in the database?

Also, I think there may be other problems, but this one obviously ruined our site performance recently, including (we think maybe) causing a crash, many hours of debugging etc.

Did I miss a warning somewhere about sites with many keyword searches every day?

I'm using a custom coded version of this mod on my site which has caching support. You're right, if you're getting too many hits from Google it'll kill your SQL database performance in time. You may delete the search terms with only 1 hit. Another thing you can do is wrapping the main plugin with if conditionals so it'll only be executed @ forumdisplay, showthread. Sorry, the core script is "Simple Search Cloud"...