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?