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.
  • 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
                                        • A A_WoodApple

                                          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 Offline
                                          E Offline
                                          Espen Harlinn
                                          wrote on last edited by
                                          #27

                                          On my work computer I can disable FSecure, but due to policy settings I can't change what gets checked or not - the logic of it kind of escapes me ...

                                          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
                                          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