aboutsummaryrefslogtreecommitdiffstats
path: root/system/search/main.php
diff options
context:
space:
mode:
authorThomas Lange <code@nerdmind.de>2018-04-01 19:16:13 +0200
committerThomas Lange <code@nerdmind.de>2018-04-01 19:16:13 +0200
commit91d8a28c664afa5378735bcd0efe068dd74d589f (patch)
treeae3d4809959dffbc9ea6118ecba76addd8b0abe8 /system/search/main.php
parentea29b80ec2942f7e0390e3bb98c37ac6c4c5686d (diff)
downloadblog-91d8a28c664afa5378735bcd0efe068dd74d589f.tar.gz
blog-91d8a28c664afa5378735bcd0efe068dd74d589f.tar.xz
blog-91d8a28c664afa5378735bcd0efe068dd74d589f.zip
Use method "buildByAttribute" to create Item instances for item listing
This commit significantly reduces the number of database queries required to display a list of pages, posts or users. This could be achieved by using "SELECT * FROM […]" in combination with the new implemented factory method "buildByAttribute". Previously, the first database query returned an array of unique item IDs that were then passed to the factory method "build" within the "foreach" loop which caused the application to make an additional database query like "SELECT * FROM […] WHERE id = {current_id}" for every single item ID to get it's payload data. Since this commit, this additional query for every item is not necessary anymore.
Diffstat (limited to 'system/search/main.php')
0 files changed, 0 insertions, 0 deletions