Missing data in index

We implemented Manticore search a few months ago for a project and it was working fine until we hit 6 million records in the database. Once it hit that point it kept truncating records in the indexes. I was able to “fix” it by increasing the indexer memory and write buffer but just wondering if there is a recommended memory amount based on the number of records when indexing from a Microsoft SQL database?

it kept truncating records in the indexes

Does that mean the indexer didn’t fail, but just didn’t do what you expected it to do?

if there is a recommended memory amount based on the number of records when indexing from a Microsoft SQL database?

Can you share your configuration file?