I think you can simply change you sql to select only the recently updated messages, and add to your existing index. Although adding to an existing large index also takes a long time, it should be quicker than re-building the whole index.
If your index continues to grow, you may need to have a dedicated server for indexing and searching. -- Chris Lu ------------------------- Instant Scalable Full-Text Search On Any Database/Application site: http://www.dbsight.net demo: http://search.dbsight.com Lucene Database Search in 3 minutes: http://wiki.dbsight.com/index.php?title=Create_Lucene_Database_Search_in_3_minutes On 8/31/07, bbrown <[EMAIL PROTECTED]> wrote: > > I have been fine with my database (discussion forum) to lucene. I am > taking > the simplest approach, eg; I have a discussion forum which are just text > messages, I take those out of the databse and then index the content. > > I am having troubling because I have hundreds of thousands of messages and > it > takes a while, eating my server cpu. I was thinking I would just index > say a > portion of the database. For example, index records 1-100 and then > 101-200. > Can I just index to that index directory without deleting the existing > index > segment files that are already there? Or is it more complicated than > that. > > -- > Berlin Brown > [berlin dot brown at gmail dot com] > http://botspiritcompany.com/botlist/? > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > >