Plugin activation hangs for a long time

Hi,

I tried activating this plugin today on a popular website with 8 years worth of posts and hundreds of thousands of comments, and found that activation just hangs. Eventually, I looked and found this query hung in mysql and was still executing 10+min after it started.

INSERT INTO wp_blc_synch(container_id, container_type, synched)
				  SELECT posts.id, posts.post_type, 0
				  FROM 
				    wp_posts AS posts LEFT JOIN wp_blc_synch AS synch
					ON (synch.container_id = posts.ID and synch.container_type=posts.post_type)  
				  WHERE
				  	posts.post_status IN ('publish')
	 				AND posts.post_type IN ('post', 'page')
					AND synch.container_id IS NULL

The wp_blc_synch table had roughly 2mln rows by then. I have to say, this is a terrible way to activate a plugin – apparently it creates a copy of some or all of our data as part of the activation? Why does it even need to do that?

Anyway, once I killed that query, the plugin activated after some time, but of course now it probably doesn’t have the data it needs to work properly.

Really negative initial experience with this one. I hope you can fix it.