how to make duplicate finding query faster?
Hi All,
I am uploading data into PostgreSQL using the CSV file and checking if there is any duplicates value in DB it should return a duplicate error. I am using below mention query.
if Card_Bank.objects.filter( Q(ACCOUNT_NUMBER=card_number) ).exists():
flag=2
else:
flag=1
Best Regards,
Sachin Kumar
flag=2
else:
flag=1
it is taking too much time i am using 600k cards in CSV.
Kindly help me in making the query faster.
I am using Python, Django & PostgreSQL.
-- Best Regards,
Sachin Kumar
В списке pgsql-admin по дате отправления: