10-05-2021 06:26 AM
We are trying to right size our database needs as we implement the API and had a question from a db performance perspective. We could have users who want to download 20k documents potentially. I am assuming from a db perspective that is for all intents and purposes is not a heavy lift. As I am gathering it passes the list of UNC's to the app pool and the API then does the heavy lifting work of grabbing the files. If that is a long operation could it possibly have an impact on the db from a performance perspective? Assume once the list is retrieved and given to the API, the db is out of the picture at that point?
10-05-2021 08:01 AM
Hi
Yes, you are correct. The DB will only be queried for the documents given the constraints you use for the document query (keywords, etc). Once you have the list of the documents, it will be the AppServer which is used to retrieve the files associated with the documents.
Take care.
10-05-2021 08:01 AM
Hi
Yes, you are correct. The DB will only be queried for the documents given the constraints you use for the document query (keywords, etc). Once you have the list of the documents, it will be the AppServer which is used to retrieve the files associated with the documents.
Take care.
Find what you came for
We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.