XF 2.3 Huge xf_search_index table in the DB

[hdrcweb]

Hi
Is it normal for the xf_search_index to be massive?
Mine is 710Mb, I have done a rebuild and that seemed to make it even bigger.

Also, the xf-post is 461mb, apart from text in posts, what else is stored in the table?
If I understand it correctly, images in posts are are on the disk not in the DB so what could be using this space?

 

[Chris D]

710MB is not really massive.

You can click into the table to see the rows and what is stored for yourself. There will be a row for each thread too. And then depending on other usage there will be a row for each item of content, including direct messages, profile posts, resources, media gallery etc.

As well as the text content, various metadata is stored.

There will also be indexes that also take up space.

 

[hdrcweb]

thanks.
Do post attachments get saved in the DB rather than on the disk? .pdf, .jpg etc

 

[Chris D]

They are saved on disk and have no impact on search.