The database has 1200000 entries and 20000 (not 200000 as mentioned earlier) plus new records are added and around the same number deleted.
For Full Import it takes approximately 4 minutes to Index. Regards, Anuj On Mon, 15 Apr 2019 at 07:29, Zheng Lin Edwin Yeo <edwinye...@gmail.com> wrote: > 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. > > >
