Content-Type: text/plain;
	charset=utf-8
Mime-Version: 1.0 (Mac OS X Mail 14.0 \(3654.40.0.2.32\))
Subject: Re: how to make query
From: Philip Semanchuk <philip@americanefficient.com>
In-Reply-To: 
 <CALg-PKBaGOBtLPD88JLuLkDFh6VarJraupdzOSCKxkAodyRT6w@mail.gmail.com>
Date: Thu, 7 Jan 2021 08:58:56 -0500
Cc: pgsql-sql@lists.postgresql.org
Content-Transfer-Encoding: quoted-printable
Message-Id: <B554173E-8FCB-480D-8684-8FB60F018B28@americanefficient.com>
References: 
 <CALg-PKBaGOBtLPD88JLuLkDFh6VarJraupdzOSCKxkAodyRT6w@mail.gmail.com>
To: Sachin Kumar <sachinkumaras@gmail.com>
Precedence: bulk


> On Jan 7, 2021, at 5:15 AM, Sachin Kumar <sachinkumaras@gmail.com> =
wrote:
>=20
> Hi Team,
>=20
> 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.
>=20
> We have to find data from a 2nd table that is related to the first one =
which we are checking using the loop.
>=20
> For Ex:-=20
> 10000 data - loop 10000 times=20
> to find data from the 2nd table.=20
>=20
> This makes our query too slower and it gets time out.

Hi Sachin,
I=E2=80=99m not sure based on your description, but it sounds like you =
need to tell Django to select related objects all in one query rather =
than one at a time. If that=E2=80=99s the case, then your problem is a =
Django issue, not a Postgres one. Check out select_related() --

=
https://docs.djangoproject.com/en/3.1/ref/models/querysets/#django.db.mode=
ls.query.QuerySet.select_related


Cheers
Philip=