I wish to reduce the amount of tables in some way since the performance of my datbaase server is reduced drastically because of it.

if growing the dimensions doesn't work then try growing the entire cached tables to 20000

boost the temp table size to 512mb