How big can the national debt get before it matters? Does anyone know?

Why would anyone fund the entire $25 billion wall when it makes more sense to do a $1 billion segment and judge its effectiveness and cost before making a decision on the rest?

I update my midterm election prediction.