When under compression, typically buckling is the limiting factor. Under tension, it's either the availability of raw material (rods commonly available up to 6m) or the critical bending speed (in the case of the traveling nut version). For larger strokes, the spindle can also be made in multiple parts.