Results 1 to 2 of 2

Thread: does limit 3,1 load the entire table into memory?

  1. #1
    Join Date
    Jan 2007
    Location
    Davenport, Iowa
    Posts
    2,385
    Thanks
    100
    Thanked 113 Times in 111 Posts

    Default does limit 3,1 load the entire table into memory?

    does the following
    Code:
    select * from tablename where summary LIKE '%term%' order by ID desc limit 9, 3
    load the entire table into memory?
    Last edited by james438; 10-27-2008 at 06:36 AM.

  2. #2
    Join Date
    Jan 2007
    Location
    Davenport, Iowa
    Posts
    2,385
    Thanks
    100
    Thanked 113 Times in 111 Posts

    Default

    I am going to guess that it does not load the entier database into memory.

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •