The main challenge of the agricultural sector is the increasing pressure on natural resources, mainly water and arable land. Consequently, an urgent imperative arises to explore technological advancements that can boost food production in alignment with the growing demands. The Soilless Production System (SPS) emerges as a proficient approach for managing irrigation water, thereby making a significant contribution to food security. This research focuses on the efficient use of SPS and identifies the best economic use of the soilless techniques for different crops within an area characterized by limited land and water availability. The database for the study was generated through a farm survey to investigate the benefits of adopting SPSs as a sustainable agricultural practice. A linear programming approach was applied to develop an optimization model for resource allocation and crop mix selection, considering the development opportunities through the SPSs. Different scenarios were applied in the model. The results proved that adopting SPSs is a sustainable irrigation practice, since the technique promotes water use efficiency, generates profitability, and conserves the associated natural resources. The SPSs ensure sustainable use of water resources by increasing water use efficiency. The hydroponics cultivation system had 11 ± 1.7 times higher yields but required 82 ± 11 times more energy in comparison to the lettuce crop produced by the conventional production system (CPS). The result of the optimal solution shows that the total revenue of scenarios of the study is 109% of the revenue of the original value of the largest farmer. The water resources and the investment cost as constraints in the model are totally used, but the operational costs in the optimal solutions are 74% of the total operational cost in the original data. The optimal solution showed the importance of using computerized systems in which the control of the fertigation is better.