Sachin: I don't understand the reason you bring 2 million records. Why you don't do that witht REACT? So there is not recharge the browser every time request data from server.
El jueves, 7 de enero de 2021 a las 11:13:23 UTC-3, [email protected] escribió: > I am using Python Django and PostgreSQL to build our report app. > > I am using below mention query to find some details. the query mention > below is running fine in PostgreSQL command line and giving result in 2 sc > for 2 million cards but when i i am try the same in Django application it > is taking too much of time and the web page is expired while running this > query. > > can anyone help how to make query faster in Django > > rows = M_Assign.objects.raw(''' select C.id > <http://c.id/>,M."merchant_name",C."MERCHANT_ID",S."store_id" > Owning_Store_ID ,S."store_name" Owning_Store_Name,F."franchisee_name" > Owning_Group,C."ACCOUNT_NUMBER",C."STORE_ID",C."GIFT_LIST_REF" FROM > vdaccount_card_assign C INNER JOIN vd_merchant_master M ON > C."MERCHANT_ID"=M."merchant_id" AND C."MERCHANT_ID"='003561002966107' INNER > JOIN vd_store_master S ON S."store_id"=C."GIFT_LIST_REF" OR > C."GIFT_LIST_REF"='' INNER JOIN vd_franchisee F ON > S."franchisee_id"=F."franchisee_id" ''') > -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/26fcec2b-94e4-4f42-b2e4-fdf2f881accen%40googlegroups.com.
