Yes, I have and it works fine. But after debug I see ful row from product and full row from shop.
I’m afraid for memory. One row from product ~1K, one row from shop ~1K and service information ~1K
Imagine I have one million products, so I get busy with three gigabytes of memory.
Is it correct or the memory is occupied by the number of products on the page, in my case twelve, 12 * 3K = 36K?
The memory consumption is not determined by the total number of records, but by the the LIMIT which is equal to the page size. So you don’t have to worry about the memory consumption and the execution speed as long as you are working with the decent page sizes, even if you use ActiveRecords.