When started designing the solution the size was 500 MB along with the log file, after completion its size increased to 1.6 GB with the log.
Now the solution was in production and its size is 1.96 GB, now the size was increased so much so that the solution has become very slow, and blue prism was throwing an error.
Once the error was closed its closing the Blue Prism.
Once we run BP again, then speed was in normal same as we run it for the very first time.
There might be a chance of increase in the size of databased in future.
So, If there is any solution to the above issue will be helpful.
Error related screenshot is attached for reference.