Efficient Indexing

You don't have to reindex the entire collection each time there's an update. I'm @ the pub typing this on a phone @ present, so can't (/won't) look up the docs for you, but check the docs for : you can update individual entries.

--

Adam

nikhil20101 wrote: Can I make this re-indexing happen at the background OR is there any other way to not make the user wait a long time before his form is submitted?

Both!

You could use a schedule task to do the indexing on a 'ahem' schedule.  Once a day, Once an hour or whatever might work.  This, of course, means that new data will not be indexed until the next scheduled task is executed.

You could fire off some type of asynchronous process that does the indexing, while not involving the thread that is processing the form request.  Thus that request can be allowed to complete and the user can go on their way while the indexing is occurring.  This can be done in ColdFusion with either Gateways or the <cfthread...> tags, whichever meets your needs better.  With old school servers it can also be done with the <cfhttp...> tag utilizing a timeout parameter of zero.  But that use has largely been supplanted by the <cfthread...> tag.  Just becareful that multiple users firing off multiple tasks to index your data at the same time does not cause a problem with this solution.