how to make query

From: Sachin Kumar <sachinkumaras(at)gmail(dot)com>
To: pgsql-sql(at)lists(dot)postgresql(dot)org
Subject: how to make query
Date: 2021-01-07 10:15:02
Message-ID: CALg-PKBaGOBtLPD88JLuLkDFh6VarJraupdzOSCKxkAodyRT6w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi Team,

we are using Python Django and Postgresql. Our requirement is to search 10
Million Card data and bring specific records as a result after checking the
record every time.

We have to find data from a 2nd table that is related to the first one
which we are checking using the loop.

For Ex:-
10000 data - loop 10000 times
to find data from the 2nd table.

This makes our query too slower and it gets time out.

--

Best Regards,
Sachin Kumar

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Sachin Kumar 2021-01-07 11:55:42 PostgreSQL Django Query
Previous Message Thomas Kellerer 2020-12-29 14:14:05 Re: JSON path query returns duplicate values