Suppose we have a standard Ito process $dX_{t}=\mu\left(X_{t},t\right)dt+\sigma\left(X_{t},t\right)dW_{t}$.
As far as I know, there are two approaches to solve this numerically: to frame it as a PDE and solve it, or to simulate random paths using Monte Carlo methods, and from there calculate expectations value which will give us prices of financial instruments. The accuracy will then scale like $C/\sqrt{N}$, where $N$ is the number of samples.
I would like to understand the limitations of Monte Carlo methods for this type of simulations, and more specifically to know whether there are problems in finance where this type of simulations are unfeasible. I know that, when we have many dimensions, the PDE method is unfeasible, and the only option is to use Monte Carlo methods. I'm also aware that the convergence rate is not too good, since there is a $\sqrt{N}$, so it might be expensive to get solutions with high accuracy.
However, I would like to understand what is the behaviour of $C$. I would assume that it depends a lot on the specific problem, but in general, I would expect that $C$ could depend on the simulation time $t$, or on the dimensions $d$. Can we say anything about the scaling though? For example, could there be any cases where $C$ increases exponentially with $t$? If that were the case for a specific problem, it would be unfeasible to simulate it with Monte-Carlo techniques for large times, since the number of samples needed to maintain a certain accuracy would also increase exponentially with time. Are there any cases in finance where $C$ scales badly, therefore making it hard to simulate the process using Monte Carlo techniques? Also, do you know of any reference where I could read about this?
Thank you very much.