CAML Query to search a document library

Jul 29, 2010 at 7:23 PM

We have a document library where we have 70,000 documents. The requirement is that documents should be searchable\available the next second after the documents are uploaded

For which we have used CAML query.

After using CAML the retrieval of the documents from the library is fast and good.
Within the CAML query we are asking it to Query a single Custom Column in the SharePoint document library

Will the CAML query work the same way if the documents in the library increase?
If yes what steps can be taken to improve?
Are there any limitations for the CAML query?