id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
35596	Database access optimization warning that get() can retrieve hundreds or thousands of records is outdated	Francisco Couzo	Ripoohann S Kumar	"> 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"	Bug	assigned	Documentation		Normal			Francisco Couzo	Accepted	0	0	0	0	0	0