This question is related to the best practice to fetch data from mysql using django. Actually i know how to use objects.all() & other methods to fetch/insert/update data. But as we all are aware of the advantages of using Stored Procedures so i planned to use Stored Procedures instead of using the objects.all() & other methods.

As per my understanding using objects.all() methods will first convert the statements into queries which will then fetch the data, so the overall process might take some time. But on my research of using SPs with Django, a lot of people have recommended to use SPs only as the last option. Hence, kindly suggest using which way i can get the best performance out of django fetching data from database.

P.S. My application idea is going to take hugh load of database transactions, so please consider the same in replying to the above post. TIA