It depends on the specific case.
If the iterative solver has to be used because the main memory is not sufficient for using the direct solver, it makes sense to expand the memory so that the direct solver can be used. In this case, the limits are set by the hardware (processor, mainboard) and the operating system.
If the RAM is sufficient to use the direct solver, further upgrade of the RAM speeds up the calculation insignificantly.