Opened 4 months ago

Last modified 4 months ago

#35596 assigned Bug

Database access optimization warning that get() can retrieve hundreds or thousands of records is outdated

Reported by: Francisco Couzo Owned by: Ripoohann S Kumar
Component: Documentation Version:
Severity: Normal Keywords:
Cc: Francisco Couzo Triage Stage: Accepted
Has patch: no Needs documentation: no
Needs tests: no Patch needs improvement: no
Easy pickings: no UI/UX: no

Description

Second, the lookup doesn’t guarantee that only one object will be returned. If the query matches more than one object, it will retrieve and transfer all of them from the database. This penalty could be substantial if hundreds or thousands of records are returned. The penalty will be compounded if the database lives on a separate server, where network overhead and latency also play a factor.

This was modified 5 years ago in commit 330638b89f14e1fb06e9d313ccc9768ae167c53f

There is one specific case when get() can return all the result set, which is when using the oracle db and select_for_update

Change History (2)

comment:1 by Ripoohann S Kumar, 4 months ago

Owner: set to Ripoohann S Kumar
Status: newassigned

comment:2 by Sarah Boyce, 4 months ago

Summary: Database access optimization page has outdated infoDatabase access optimization warning that get() can retrieve hundreds or thousands of records is outdated
Triage Stage: UnreviewedAccepted

A docs link for reference: https://docs.djangoproject.com/en/5.0/topics/db/optimization/#retrieve-individual-objects-using-a-unique-indexed-column

Agreed an update here would be nice, thank you for the report 👍 refs #6785

Note: See TracTickets for help on using tickets.
Back to Top