What is a cost-effective solution to lift water from a tubewell?

I am in the process of digging a 6 inch tubewell for irrigation purposes. Depth of the bore will be 650 feet. Kindly advise a cost effective solution to lift water from 500 -600 feet from ground level. Which option will be cost effective i.e., compressor pump or submersible pump ?
×