duanbing6955 2015-12-08 07:10
浏览 47


I am developing a set of backend APIs which will be used by an android/iphone app. There are instances where I have to use joins of more than 2 or 3 tables.

For example:

I have a products table that is associated with its likes, SKU's, comments, and category tables. If I am using eager loading to get all the values associated with the products table, it's going to execute the following queries:

select * from `products` where `products`.`products_id` = '1'
select * from `skus` where `skus`.`products_id` in ('1')
select * from `likes` where `likes`.`products_id` in ('1')
select * from `comments` where `comments`.`products_id` in ('1')

This has run 4 queries with all '*'. If I need to have specific columns to be selected, I will have to hardcode it in the model relationship function and it will not be dynamic. This will kill the performance and scalability of my application.

Where does the eloquent model come into play? Does it just give the advantage of faster development and an abstraction layer from the queries? Or are there any specific places where I can use eloquent model without compromising performance? What I understand is, if I have more tables, I better be using joins rather than eloquent?

  • 写回答

1条回答 默认 最新

  • dsfbnhc4373 2015-12-08 08:04

    Eloquent is an ORM. This ennables a user to use objective approach to set data and not to worry about how it is stored. No need to worry abbout sql injections and so on. But every ORM has a drawback. On (retrieving) complex data sets raw SQL is much more efficient in allot of cases. You can execute raw sql like this:

    $products = \DB::table('products')
        ->where('products_id', 1)
        ->join('skus', 'skus.product_id', '=', 'products.product_id')
        ->join('likes', 'likes.product_id', '=', 'products.product_id')
        ->join('comments', 'comments.product_id', '=', 'products.product_id');
    本回答被题主选为最佳回答 , 对您是否有帮助呢?



  • ¥50 python课程管理系统
  • ¥15 python+selenium,在新增时弹出了一个输入框
  • ¥15 苹果验机结果的api接口哪里有??单次调用1毛钱及以下。
  • ¥20 学生成绩管理系统设计
  • ¥15 来一个cc穿盾脚本开发者
  • ¥15 CST2023安装报错
  • ¥15 使用diffusionbert生成文字 结果是PAD和UNK怎么办
  • ¥15 有人懂怎么做大模型的客服系统吗?卡住了卡住了
  • ¥20 firefly-rk3399上启动卡住了
  • ¥15 如何删除这个虚拟音频