Uploaded image for project: 'Mongoid'
  1. Mongoid
  2. MONGOID-4131

Every reference to a Criteria fires a database query?

    • Type: Icon: Task Task
    • Resolution: Done
    • Priority: Icon: Major - P3 Major - P3
    • 12_01_17
    • Affects Version/s: None
    • Component/s: None
    • Labels:
      None

      Hi, I'm new to Mongoid and one problem blows up my mind.

              drawings = Drawing.published.includes(:user).limit(10)
              drawing_ids = drawings.map(&:id)
              drawing_ids = drawings.map(&:id)
              drawing_ids = drawings.map(&:id)
      

      logs:

      Started GET "/api/hot?session=_9KE3K-hOXmJ0rbUFAku4Q" for ::1 at 2015-07-17 18:15:03 +0800
        MOPED: 127.0.0.1:27017 COMMAND      database=admin command={:ismaster=>1} runtime: 1.1360ms
        MOPED: 127.0.0.1:27017 QUERY        database=ki_backend_development collection=drawings selector={"published"=>true} flags=[] limit=10 skip=0 batch_size=nil fields=nil runtime: 1.7850ms
        MOPED: 127.0.0.1:27017 KILL_CURSORS cursor_ids=[40750436337] runtime: 0.6160ms
        MOPED: 127.0.0.1:27017 QUERY        database=ki_backend_development collection=users selector={"_id"=>{"$in"=>[3, 7, 10, 9, 4, 16, 11]}} flags=[] limit=0 skip=0 batch_size=nil fields=nil runtime: 1.0660ms
        MOPED: 127.0.0.1:27017 QUERY        database=ki_backend_development collection=drawings selector={"published"=>true} flags=[] limit=10 skip=0 batch_size=nil fields=nil runtime: 0.8580ms
        MOPED: 127.0.0.1:27017 KILL_CURSORS cursor_ids=[38905434652] runtime: 0.1460ms
        MOPED: 127.0.0.1:27017 QUERY        database=ki_backend_development collection=drawings selector={"published"=>true} flags=[] limit=10 skip=0 batch_size=nil fields=nil runtime: 1.0710ms
        MOPED: 127.0.0.1:27017 KILL_CURSORS cursor_ids=[38960364161] runtime: 0.4690ms
      
      

      Am I missing something?

            Assignee:
            Unassigned Unassigned
            Reporter:
            limbo-lab limbo-lab
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: