V
V
valexeich2022-04-21 12:33:44
Django
valexeich, 2022-04-21 12:33:44

How many sql queries per page is a lot?

On page 44 of my sql query, is this considered a lot or a little? What counts as a lot? What is considered small?

Answer the question

In order to leave comments, you need to log in

2 answer(s)
D
Dr. Bacon, 2022-04-21
@valexeich

Depends on requests, if it "N+1 selects problem" that is bad. I had specific pages with 50-150 requests, but they were all in the region of 50ms, so they did not cause problems

V
Vladimir Korotenko, 2022-04-21
@firedragon

Don't care how much.
Your main task is to generate a page in a time acceptable to the user and not go broke on the server.
In general, you see
total:
sql query: 44
sql time: 0.037s
generation: 0.5s
this is all for an example.
If it suits you, leave it, if not, fix a weak spot, or buy a more expensive server

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question