Im not sure what you did in the update, but it totally kills the site, had to disable the plugin completely now.

The TP table instantly grew to 65GB in size & i had to truncate it.

If i disable Use for Blocks, save the changes & reset the building of indexes this is getting turned back on by itself?

Enable Index Optimizer - Enabled
wpftsi_tp ~260,116,167 InnoDB 25.8 GiB
wpftsi_vectors ~292,656,079 InnoDB 17.5 GiB

Indexing... 99.99%
Pending: 1 of 471053
Est. Time: 00:00:00

Optimizing... 0.00%
Records: 471053
...Ready for changes...

Hi, ive installed the free version of your search program to see how well it works & decide if im going to get the pro version of it.

In this process, the product seems to work well, but it has created 2 db tables that are huge in size.

WP's DB size by default with 460k posts is only 6GB

Your two tables are:
tp - 26GB
vectors 18GB

Indexing regardless takes a day to process & is now flipping between optimizing which never does any counting & the indexing what i would assume is a new post.

This is after the initial indexing that took 1 day to do.

Are the 2 tables going to be removed as they are ridiculous in size after the indexing is complete?