Reading the documentation, I see this mention :
For large data sets, it is much faster to load your data into a table that has no FULLTEXT index and then create the index after that, than to load data into a table that has an existing FULLTEXT index.
I understand the requirements behind building the index, but how "much [slower]" is it to directly insert data into a table with a FULLTEXT index? Is there actual data to give an idea of this?
I need to create a table which will perform about 2,000 inserts each day, and we expect this amount to climb up to 5,000 inserts in the next years. So, between about 70k and 180k entries each year.
So, I'm trying to assess if I really need to have two tables, i.e. one without an index, and another with a full-text index, or if I can insert directly into the table with the full-text search with negligible impact over time.
There are no DBAs, here, and the current MySQL installation went through a few updates already over the last +decade, so there is nothing fancy going on with the current setup.
Thank you for any useful information you can provide me with.
** Edit **
I typically create tables using the InnoDB engine.