Have you tried how long does it take to index all the entries? Regards, Edwin
On Fri, 12 Apr 2019 at 12:32, Anuj Bhargava <anujb...@gmail.com> wrote: > We have a MySql database (news) which has the following fields - > posting_id, date, name, currency, country, expiry ....etc > > The database has more than 1200000 entries. Daily around 200000 plus new > records are added and around the same number deleted. > > posting_id is a unique ID for every record. > > Please can some help write a delta-import script so that the index file is > update as per the records in the MySql database (news) everyday. If the > posting_id is not found in the database (news) then the same is deleted > from the solr indexed file and the records with new posting_id are indexed. >