Could you just work off an extract of the data until you get the viz you want, and then turn the connection back live?
First up, for faster performance, I recommend using an extract. Once you go that route, I think setting up a time to refresh is more efficient than triggering a refresh every time you add a record. This is usually done by setting up an "Incremental Refresh" on your server. More info - Refresh Extracts