diff options
| author | Thomas Lange <code@nerdmind.de> | 2018-04-01 19:16:13 +0200 |
|---|---|---|
| committer | Thomas Lange <code@nerdmind.de> | 2018-04-01 19:16:13 +0200 |
| commit | 91d8a28c664afa5378735bcd0efe068dd74d589f (patch) | |
| tree | ae3d4809959dffbc9ea6118ecba76addd8b0abe8 /system/search/main.php | |
| parent | ea29b80ec2942f7e0390e3bb98c37ac6c4c5686d (diff) | |
| download | blog-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