Regarding low yield of borewell water in Velayuthapalyam, TN - Is a compressor pump recommended


We have a 100 feet depth bore in our home, which was created 1 year ago.  Recently, we inserted a submersible motor of 1 hp, but the water flow was intermittent with a good force of water.  The water flow stops in 10 minutes and again the motor has to run about 10 minutes to produce water. Our engineer advised that submersible pump is not suitable for low yield of water and recommended a compressor pump.  Is it okay to use a compressor pump or should I go for other options? Please advise me.