Indexing previous records with Doctrine (and Symfony!) with Zend Lucene

Question

I have a Symfony application that uses Doctrine as its ORM. Based on Symfony's "Practical symfony" book, I have Zend Lucene added to my web app.

However, the problem is that there are around 1.1 million rows existing in the database that I want to index for Lucene as well. The only things being indexed are edited rows and the rows have been added since I starting using Lucene (about 50-75k).

I'm not sure the best method to go about this, so I figured I would ask some opinions.

Answer 1

I created a task that clears the current index and rebuilds it with all the records. It's on github, you can find it here. Although it uses propel, you should be able to adapt it for your needs.