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. Multi-task

Multi-task

Scheduled Pinned Locked Moved The Lounge
databaseperformance
27 Posts 10 Posters 7 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.
  • C Corporal Agarn

    I love the way computers multi-task. As long as you do one thing at a time.:mad: Running a database restore that is tying up the computer. CPU 3%, system has 8G memory, maximum ever used 6.3G, maxed out. I even had trouble trying to write this.

    J Offline
    J Offline
    jim lahey
    wrote on last edited by
    #7

    It's the only way: http://cache.ohinternet.com/images/e/e9/Advice_dog_system_32.jpg[^]

    C 1 Reply Last reply
    0
    • R Rutvik Dave

      It's not the RAM utilization slowing down your computer, it's the IO operations causing the slowdown. Even your boot will be very slow if you have SQL Server or any other database engine installed.

      Remind Me This - Manage, Collaborate and Execute your Project in the Cloud

      C Offline
      C Offline
      Corporal Agarn
      wrote on last edited by
      #8

      I know, but I still complain.

      1 Reply Last reply
      0
      • J jim lahey

        It's the only way: http://cache.ohinternet.com/images/e/e9/Advice_dog_system_32.jpg[^]

        C Offline
        C Offline
        Corporal Agarn
        wrote on last edited by
        #9

        System 32 is over rated. :)

        1 Reply Last reply
        0
        • E Espen Harlinn

          Guess what happens when you run Oracle, SQL Server, Interbase & Blackfish on your laptop ...

          Espen Harlinn Principal Architect, Software - Goodtech Projects & Services AS Projects promoting programming in "natural language" are intrinsically doomed to fail. Edsger W.Dijkstra

          M Offline
          M Offline
          Matthew Faithfull
          wrote on last edited by
          #10

          Very very little at all? :-D

          "The secret of happiness is freedom, and the secret of freedom, courage." Thucydides (B.C. 460-400)

          E 1 Reply Last reply
          0
          • M Matthew Faithfull

            Very very little at all? :-D

            "The secret of happiness is freedom, and the secret of freedom, courage." Thucydides (B.C. 460-400)

            E Offline
            E Offline
            Espen Harlinn
            wrote on last edited by
            #11

            Matthew Faithfull wrote:

            Very very little at all?

            Yes, you do get time a cup, or two, of your favourite beverage in the morning ...

            Espen Harlinn Principal Architect, Software - Goodtech Projects & Services AS Projects promoting programming in "natural language" are intrinsically doomed to fail. Edsger W.Dijkstra

            1 Reply Last reply
            0
            • E Espen Harlinn

              Guess what happens when you run Oracle, SQL Server, Interbase & Blackfish on your laptop ...

              Espen Harlinn Principal Architect, Software - Goodtech Projects & Services AS Projects promoting programming in "natural language" are intrinsically doomed to fail. Edsger W.Dijkstra

              R Offline
              R Offline
              Rutvik Dave
              wrote on last edited by
              #12

              then you can hear your HDD scream while your CPU sit back and relax at 15% :-D

              Remind Me This - Manage, Collaborate and Execute your Project in the Cloud

              E 1 Reply Last reply
              0
              • R Rutvik Dave

                then you can hear your HDD scream while your CPU sit back and relax at 15% :-D

                Remind Me This - Manage, Collaborate and Execute your Project in the Cloud

                E Offline
                E Offline
                Espen Harlinn
                wrote on last edited by
                #13

                Not sure - it takes 15-20 minutes before the logon completes ... hopefully this will work way better on my new machine - which I hope I will actually start using one of these days ;)

                Espen Harlinn Principal Architect, Software - Goodtech Projects & Services AS Projects promoting programming in "natural language" are intrinsically doomed to fail. Edsger W.Dijkstra

                R 1 Reply Last reply
                0
                • E Espen Harlinn

                  Not sure - it takes 15-20 minutes before the logon completes ... hopefully this will work way better on my new machine - which I hope I will actually start using one of these days ;)

                  Espen Harlinn Principal Architect, Software - Goodtech Projects & Services AS Projects promoting programming in "natural language" are intrinsically doomed to fail. Edsger W.Dijkstra

                  R Offline
                  R Offline
                  Rutvik Dave
                  wrote on last edited by
                  #14

                  What!!!? You actually have all of these installed on your laptop? I thought you are pointing out a possible scenario. :) Don't you have an older desktop/laptop laying around? You have way too much patience... you must be writing some quality code :)

                  Remind Me This - Manage, Collaborate and Execute your Project in the Cloud

                  E 1 Reply Last reply
                  0
                  • R Rutvik Dave

                    What!!!? You actually have all of these installed on your laptop? I thought you are pointing out a possible scenario. :) Don't you have an older desktop/laptop laying around? You have way too much patience... you must be writing some quality code :)

                    Remind Me This - Manage, Collaborate and Execute your Project in the Cloud

                    E Offline
                    E Offline
                    Espen Harlinn
                    wrote on last edited by
                    #15

                    Rutvik Dave wrote:

                    You actually have all of these installed on your laptop?

                    I do ... which is why I have some hope for my new laptop, a thorougly uppgraded HP 8570w The odd thing is that, once everything is up and running, I can actually get pretty decent performance out of the database servers ...

                    Espen Harlinn Principal Architect, Software - Goodtech Projects & Services AS Projects promoting programming in "natural language" are intrinsically doomed to fail. Edsger W.Dijkstra

                    R 1 Reply Last reply
                    0
                    • E Espen Harlinn

                      Rutvik Dave wrote:

                      You actually have all of these installed on your laptop?

                      I do ... which is why I have some hope for my new laptop, a thorougly uppgraded HP 8570w The odd thing is that, once everything is up and running, I can actually get pretty decent performance out of the database servers ...

                      Espen Harlinn Principal Architect, Software - Goodtech Projects & Services AS Projects promoting programming in "natural language" are intrinsically doomed to fail. Edsger W.Dijkstra

                      R Offline
                      R Offline
                      Rutvik Dave
                      wrote on last edited by
                      #16

                      Espen Harlinn wrote:

                      The odd thing is that, once everything is up and running, I can actually get pretty decent performance out of the database servers ...

                      Interesting... I don't know what is you requirement regarding mobility, but I would let everything installed on the older/existing laptop and install the client software on the new shiny HP 8570w and then connect to the older laptop The Database Server (which I would never turn off). :)

                      Remind Me This - Manage, Collaborate and Execute your Project in the Cloud

                      E 1 Reply Last reply
                      0
                      • E Espen Harlinn

                        Guess what happens when you run Oracle, SQL Server, Interbase & Blackfish on your laptop ...

                        Espen Harlinn Principal Architect, Software - Goodtech Projects & Services AS Projects promoting programming in "natural language" are intrinsically doomed to fail. Edsger W.Dijkstra

                        C Offline
                        C Offline
                        Chris Maunder
                        wrote on last edited by
                        #17

                        Remember: don't cross the streams!

                        cheers, Chris Maunder The Code Project | Co-founder Microsoft C++ MVP

                        E 1 Reply Last reply
                        0
                        • R Rutvik Dave

                          Espen Harlinn wrote:

                          The odd thing is that, once everything is up and running, I can actually get pretty decent performance out of the database servers ...

                          Interesting... I don't know what is you requirement regarding mobility, but I would let everything installed on the older/existing laptop and install the client software on the new shiny HP 8570w and then connect to the older laptop The Database Server (which I would never turn off). :)

                          Remind Me This - Manage, Collaborate and Execute your Project in the Cloud

                          E Offline
                          E Offline
                          Espen Harlinn
                          wrote on last edited by
                          #18

                          Rutvik Dave wrote:

                          requirement regarding mobility

                          I tend to do a wee bit of work outside regular hours - so I bring the development box with me when I leave the office. Work supplies me with the laptop, at home I'm somewhat better equipped ...

                          Espen Harlinn Principal Architect, Software - Goodtech Projects & Services AS Projects promoting programming in "natural language" are intrinsically doomed to fail. Edsger W.Dijkstra

                          N 1 Reply Last reply
                          0
                          • C Chris Maunder

                            Remember: don't cross the streams!

                            cheers, Chris Maunder The Code Project | Co-founder Microsoft C++ MVP

                            E Offline
                            E Offline
                            Espen Harlinn
                            wrote on last edited by
                            #19

                            The caffeine also helps to boot up 'Ze Little Grey Cells' for the day ... I've never been a great fan of mornings ...

                            Espen Harlinn Principal Architect, Software - Goodtech Projects & Services AS Projects promoting programming in "natural language" are intrinsically doomed to fail. Edsger W.Dijkstra

                            1 Reply Last reply
                            0
                            • E Espen Harlinn

                              Rutvik Dave wrote:

                              requirement regarding mobility

                              I tend to do a wee bit of work outside regular hours - so I bring the development box with me when I leave the office. Work supplies me with the laptop, at home I'm somewhat better equipped ...

                              Espen Harlinn Principal Architect, Software - Goodtech Projects & Services AS Projects promoting programming in "natural language" are intrinsically doomed to fail. Edsger W.Dijkstra

                              N Offline
                              N Offline
                              Nicholas Marty
                              wrote on last edited by
                              #20

                              Do you need all those engines at startup or only on demand? Maybe just disabling the automatic start of all those greedy databases might improve your boot time? :)

                              E 1 Reply Last reply
                              0
                              • N Nicholas Marty

                                Do you need all those engines at startup or only on demand? Maybe just disabling the automatic start of all those greedy databases might improve your boot time? :)

                                E Offline
                                E Offline
                                Espen Harlinn
                                wrote on last edited by
                                #21

                                Did that for a while, but lately I need both when I start working - disabling Oracle helped a bit, cutting about 5 minutes of the time required to boot, disabling MS SQL Server didn't make much of a difference. Disabling FSecure made a lot of difference ... but then we're not supposed to do that, so I turned it back on. So FSecure is probably the real culprit, but it behaved well enough before I installed the servers.

                                Espen Harlinn Principal Architect, Software - Goodtech Projects & Services AS Projects promoting programming in "natural language" are intrinsically doomed to fail. Edsger W.Dijkstra

                                N A 2 Replies Last reply
                                0
                                • E Espen Harlinn

                                  Did that for a while, but lately I need both when I start working - disabling Oracle helped a bit, cutting about 5 minutes of the time required to boot, disabling MS SQL Server didn't make much of a difference. Disabling FSecure made a lot of difference ... but then we're not supposed to do that, so I turned it back on. So FSecure is probably the real culprit, but it behaved well enough before I installed the servers.

                                  Espen Harlinn Principal Architect, Software - Goodtech Projects & Services AS Projects promoting programming in "natural language" are intrinsically doomed to fail. Edsger W.Dijkstra

                                  N Offline
                                  N Offline
                                  Nicholas Marty
                                  wrote on last edited by
                                  #22

                                  Or then just delay the automatic start of the services until you're logged in (e.g. write a short batch script and move it in the autorun folder ;P) so you can in the meantime start more (or less) important things like codeproject (most important ;)) or checking the mailbox Otherwise: Set up WOL an boot the computer from your mobile phone :laugh: (tried this with my pc at home ;))

                                  E 1 Reply Last reply
                                  0
                                  • N Nicholas Marty

                                    Or then just delay the automatic start of the services until you're logged in (e.g. write a short batch script and move it in the autorun folder ;P) so you can in the meantime start more (or less) important things like codeproject (most important ;)) or checking the mailbox Otherwise: Set up WOL an boot the computer from your mobile phone :laugh: (tried this with my pc at home ;))

                                    E Offline
                                    E Offline
                                    Espen Harlinn
                                    wrote on last edited by
                                    #23

                                    And loose my valuable 20 minutes for coffee and inane chatter? :omg:

                                    Espen Harlinn Principal Architect, Software - Goodtech Projects & Services AS Projects promoting programming in "natural language" are intrinsically doomed to fail. Edsger W.Dijkstra

                                    N 1 Reply Last reply
                                    0
                                    • E Espen Harlinn

                                      And loose my valuable 20 minutes for coffee and inane chatter? :omg:

                                      Espen Harlinn Principal Architect, Software - Goodtech Projects & Services AS Projects promoting programming in "natural language" are intrinsically doomed to fail. Edsger W.Dijkstra

                                      N Offline
                                      N Offline
                                      Nicholas Marty
                                      wrote on last edited by
                                      #24

                                      Haha, I don't need 20 minutes boottime to do that :laugh:

                                      E 1 Reply Last reply
                                      0
                                      • N Nicholas Marty

                                        Haha, I don't need 20 minutes boottime to do that :laugh:

                                        E Offline
                                        E Offline
                                        Espen Harlinn
                                        wrote on last edited by
                                        #25

                                        Nicholas Marty wrote:

                                        I don't need 20 minutes boot time to do that

                                        it's a pleasant way to start the day, and the chatter isn't really inane - once I start working, getting disturbed is sometimes more than a bit annoying.

                                        Espen Harlinn Principal Architect, Software - Goodtech Projects & Services AS Projects promoting programming in "natural language" are intrinsically doomed to fail. Edsger W.Dijkstra

                                        1 Reply Last reply
                                        0
                                        • E Espen Harlinn

                                          Did that for a while, but lately I need both when I start working - disabling Oracle helped a bit, cutting about 5 minutes of the time required to boot, disabling MS SQL Server didn't make much of a difference. Disabling FSecure made a lot of difference ... but then we're not supposed to do that, so I turned it back on. So FSecure is probably the real culprit, but it behaved well enough before I installed the servers.

                                          Espen Harlinn Principal Architect, Software - Goodtech Projects & Services AS Projects promoting programming in "natural language" are intrinsically doomed to fail. Edsger W.Dijkstra

                                          A Offline
                                          A Offline
                                          A_WoodApple
                                          wrote on last edited by
                                          #26

                                          Espen Harlinn wrote: So FSecure is probably the real culprit Hmm.. I would exclude the directory containing your database data from any virus scans.(like FSecure) This might improve your boot time and will also help insure that it does not corrupt your data.

                                          E 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