MIME-Version: 1.0
From: Sachin Kumar <sachinkumaras@gmail.com>
Date: Thu, 7 Jan 2021 15:45:02 +0530
Message-ID: 
 <CALg-PKBaGOBtLPD88JLuLkDFh6VarJraupdzOSCKxkAodyRT6w@mail.gmail.com>
Subject: how to make query
To: pgsql-sql@lists.postgresql.org
Content-Type: multipart/alternative; boundary="0000000000009f9fcb05b84cb881"
Precedence: bulk

--0000000000009f9fcb05b84cb881
Content-Type: text/plain; charset="UTF-8"

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

--0000000000009f9fcb05b84cb881
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Hi Team,<div><br></div><div>we are using Python Django and=
 Postgresql. Our requirement is to=C2=A0search 10 Million Card data and bri=
ng specific records as a result after checking the record every time.</div>=
<div><br></div><div>We have to find data from a 2nd table that is related t=
o the first one which we are checking using the loop.</div><div><br></div><=
div>For Ex:-=C2=A0</div><div>10000 data - loop 10000 times=C2=A0</div><div>=
to find data from the 2nd table.=C2=A0</div><div><br></div><div>This makes =
our query too slower and it gets time out.</div><div><br></div>-- <br><div =
dir=3D"ltr" class=3D"gmail_signature" data-smartmail=3D"gmail_signature"><b=
r>Best Regards, <br>Sachin Kumar<br></div><img width=3D"1" height=3D"1" src=
=3D"http://s.bl-1.com/McyF4gD.gif"></div>

--0000000000009f9fcb05b84cb881--