Vimeo Issue with wp_options table

After installing FV Player Pro with Vimeo Pro (also using VAST plugin) yesterday, my website has really slowed down.

I normally monitor my mysql.slow log for bottlenecks, after installing the FV player it started to flood with these entries:
SELECT option_name, option_value FROM wp_options WHERE autoload = ‘yes’;
Some queries taking up to 20 seconds, during heavy site traffic.

From what have read, wordpress runs this query every time someone visits a page, and it loads all that data into memory? It looks like FV Player takes and stores all the vimeo rest api results for each video in the wp_options table with autoload set to yes. The option_value also looks rather large since it holds a lot of information from that endpoint. I tried adding an index on that table to speed things up:
create index i1 on wp_options(autoload, option_name, option_value(50))

It helped some, but when the cached vimeo entries in that table starts to get up to 500 (have over 1000 videos on the site), and the server starts to get moderate traffic, the site starts to crawl again. If I manually delete those out of the wp_options table, things speed back up again.

Any ideas?

Maybe store that vimeo api data in text files in /wp-content/uploads/flplayer/vimeo/vimeo_id
Or not having it set to autoload if stored in wp_options?

Any help or suggestions would be appreciated, it’s a great plugin other then this first initial issue I’m having.

Thanks