title: Prestashop 1.6 - Search indexing keeps starting from 0 products
body: <p>we have migrated 190000 products from a remote database to our Prestashop database. We have tried several times to use the indexing option that Prestashop offers through its administrator environment but indexing keeps going to zero and starting from the beginning. We click only the option "Add missing products to the index" and not "Rebuild the entire index". However, the process keeps starting from the beginning. Additionally, we have disabled the automatic indexing process.</p>
  
  <p>So, the question is what can we do in order to finish the search indexing normally?</p>
  
  <p>Extra info that may help:</p>
  
  <ul>
  <li>We execute a cron job script that updates some products (about 100) every night at 03:00. However, the indexing process gets to zero even when then cron jobs doesn't run.</li>
  <li>During migration process, we exported the source database to CSV files. Then, we imported the CSV data to Prestashop database by using "LOAD DATA INFILE". We did a full export of database, full import and optimized the tables. However, the site is extremely slow except from the pages that are cached.</li>
  </ul>