CategoryJoins for ItemManager 2.2+ - Printable Version +- GetSimple Support Forum (http://get-simple.info/forums) +-- Forum: GetSimple (http://get-simple.info/forums/forumdisplay.php?fid=3) +--- Forum: Scripts & Components (http://get-simple.info/forums/forumdisplay.php?fid=11) +--- Thread: CategoryJoins for ItemManager 2.2+ (/showthread.php?tid=8017) |
CategoryJoins for ItemManager 2.2+ - Bigin - 2016-02-20 CategoryJoins for ItemManager Joins are used to combine fields into one data item from two or more categories For very large item-objects (with bigger field values for example) and a large number of items it is sometimes advisable to split the item into two parts, and load them only at the time when they are really needed. This improves loading efficiency and saves performance for both the server and client. Let's say we have a Members-Category with a large number of items and a number of input fields (about 12) for the address data. It's rather inefficient to spend lots of memory to fully load all the member-objects with all the address field data if we only wish to display a list of user names for example. The one reasonable solution would be to split the members into two parts/categories: Members and Addresses with following fields. 1. Members: 2. Addresses: Member list view in admin: With a very small members-objects, we can now handle very well and load the address-data by the item id only at the time when it’s really needed: PHP Code: $manager = new IManager(); |