Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. The Lounge
  3. If a CPU cycle took one second, how long would it take to get a record from the database?

If a CPU cycle took one second, how long would it take to get a record from the database?

Scheduled Pinned Locked Moved The Lounge
databasequestion
6 Posts 6 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • M Offline
    M Offline
    Mat Fergusson
    wrote on last edited by
    #1

    I read something like this on the web recently but I cannot for the life of me find it again. Does anyone here remember such a piece? Do you happen to have the URL to hand? Massive thanks in advance to the winner.

    RaviBeeR L J R S 5 Replies Last reply
    0
    • M Mat Fergusson

      I read something like this on the web recently but I cannot for the life of me find it again. Does anyone here remember such a piece? Do you happen to have the URL to hand? Massive thanks in advance to the winner.

      RaviBeeR Offline
      RaviBeeR Offline
      RaviBee
      wrote on last edited by
      #2

      It's mentioned in Systems Performance: Enterprise and the Cloud[^] by Brendan Gregg. /ravi

      My new year resolution: 2048 x 1536 Home | Articles | My .NET bits | Freeware ravib(at)ravib(dot)com

      1 Reply Last reply
      0
      • M Mat Fergusson

        I read something like this on the web recently but I cannot for the life of me find it again. Does anyone here remember such a piece? Do you happen to have the URL to hand? Massive thanks in advance to the winner.

        L Offline
        L Offline
        Lost User
        wrote on last edited by
        #3

        There are hundreds of those. Maybe this one? http://norvig.com/21-days.html#answers[^] Approximately infinitely long. edit: modify "execute typical instruction" to 0.25ns. Nontypical instructions take longer.

        1 Reply Last reply
        0
        • M Mat Fergusson

          I read something like this on the web recently but I cannot for the life of me find it again. Does anyone here remember such a piece? Do you happen to have the URL to hand? Massive thanks in advance to the winner.

          J Offline
          J Offline
          Jeremy Falcon
          wrote on last edited by
          #4

          Well given the typical 3GHz clock rate, everything would take 3 billion times as long than 1 hertz. So using the link above, accessing 1MB of memory would take approximately 1.9 years. And that's with no special calculations on top of it.

          Jeremy Falcon

          1 Reply Last reply
          0
          • M Mat Fergusson

            I read something like this on the web recently but I cannot for the life of me find it again. Does anyone here remember such a piece? Do you happen to have the URL to hand? Massive thanks in advance to the winner.

            R Offline
            R Offline
            Roger Wright
            wrote on last edited by
            #5

            If a CPU cycle took one second, you'd have been dead of old age before your post here was displayed. In fact, you probably would have retired before the machine responded to your click on the Post message button which, in turn, would have been initialized sometime before you were born. ;P

            Will Rogers never met me.

            1 Reply Last reply
            0
            • M Mat Fergusson

              I read something like this on the web recently but I cannot for the life of me find it again. Does anyone here remember such a piece? Do you happen to have the URL to hand? Massive thanks in advance to the winner.

              S Offline
              S Offline
              Simon ORiordan from UK
              wrote on last edited by
              #6

              Coming up.......nnnnnnnow!

              1 Reply Last reply
              0
              Reply
              • Reply as topic
              Log in to reply
              • Oldest to Newest
              • Newest to Oldest
              • Most Votes


              • Login

              • Don't have an account? Register

              • Login or register to search.
              • First post
                Last post
              0
              • Categories
              • Recent
              • Tags
              • Popular
              • World
              • Users
              • Groups