SitePoint Sponsor

User Tag List

Results 1 to 4 of 4

Thread: Basic ques.

  1. #1
    SitePoint Wizard johnn's Avatar
    Join Date
    Mar 2001
    Location
    Southern California, USA
    Posts
    1,181
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Basic ques.

    Hi,

    Say if I have query:
    "select x,y,z from tables a, b, c where....."

    Does that mean all records in three tables a,b,c must be loaded and stored in the memory of server first before the query is executed? If so, as time goes on, more records will be added to these tables, then not enough memory in server machine to store these data, so I have to buy more RAM?

    Thanks,
    John

  2. #2
    SitePoint Enthusiast Grubilo's Avatar
    Join Date
    Oct 2002
    Posts
    41
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I guess additional RAM is allways a benefit.
    But in the case you showed: if you want to return a really big number of records, your SWAP memory service on server will be used and you will be able to get all the entries but ten times or more slower...
    Web tutorials
    http://webclass.ru

  3. #3
    SitePoint Wizard johnn's Avatar
    Join Date
    Mar 2001
    Location
    Southern California, USA
    Posts
    1,181
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    So you meann
    SWAP memory service on server will be used
    You mean it uses space on hard disk to swap?

  4. #4
    SitePoint Zealot
    Join Date
    Oct 2002
    Location
    Germany
    Posts
    159
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Originally posted by johnn
    So you meannYou mean it uses space on hard disk to swap?
    bingo!


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
  •