Post reply

sql memory usage

  • April 11, 2008 at 11:49 am

    #185318

    I am usung sql 2005 studio express, my data base is using 1.200,000k that is fine i am running alot of data onto it, but i dont need to hold all the data

    I dont think its writing to disk very fast, can i make sql run faster by holding less in memory?

    regards

    Jon

  • April 14, 2008 at 7:39 am

    #802063

    I'm having trouble following your question.

    Are you asking if you can make the database faster by making more of it stay on the disk instead of in memory? That seems to be the question. If that is what you're asking, the answer is "no". Memory is faster than the disk.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply