Solr: How to add some more documents to an existing index file

[gurunath pai]

I am having an index file which contains the data from mysql database, I created this index file using dataimporthandler of solr. My requirement is, suppose if i add a new row to database, I want to update that row in my existing index file of solr. I dont have any idea how to add the new record from database to solr ? Do I need to re-index the index file again or even single record update is possible.

[Ulf Dittmer]

That's what delta queries are for: http://wiki.apache.org/solr/DataImportHandler#Using_delta-import_command

[gurunath pai]

Ulf : Ofcourse this helps to solve my problem, but I noticed i need to alter table to maintain timestamp like last modified etc. So is there any way to achieve the same without altering the table and update only those records which are recently added.