Is there anything more you can tell us? What have you done so far to troubleshoot the problem? Have you looked in the logs? Anything helpful in there? Without more info there is nothing more we can do for you.
Yes, we do upload about 300 pdf files (about 3MB each) every night (around 10pm).
However, the upload has been completed successfully every night; on the other hand, once we use the "Dashboard" for searching records (only searching) during daytime, the system hangs.
Moreover, we seldom use the "Dashboard"; we use it only 2 or 3 times a month whenever we want to verify the data.
According to the log, it seems to me that the transaction update cache has been filled up, may I know how to prevent the cache being "free up"? Such as by changing the cache settings? We already have a 16GB ram....
300 files is a tiny upload. Do you have many rules that are configured on the folders the PDFs are being uploaded to? I'm trying to understand how you are filling up the transactional cache with such a small upload.