How to optimize SQL Databases?

Discussion in 'Databases' started by Vexious, Apr 3, 2007.

0
  1. #1
    Is there any settings or anything i can do if i have a site that querys SQL a lot? Currently its a lot of messy code that I cant get fixed atm, however loading on my pages when you first load them its blank and says waiting for domain.com.....

    Is there anyway at all to help fix this problem? Caching? anything?

    Currently running on a dedicated linux centos box

    In other words what the best way to give my SQL more memory~
     
    Vexious, Apr 3, 2007 IP
  2. uranus

    uranus Peon

    Messages:
    556
    Likes Received:
    24
    Best Answers:
    0
    Trophy Points:
    0
    #2
    SQL will optimize itself with time or you can invest on a raid controller card like the compaq Smart Array 5304/256 Controller. this card has mutltiple posts. I has worked very good for me.
     
    uranus, Apr 3, 2007 IP
  3. tonyrocks

    tonyrocks Active Member

    Messages:
    1,574
    Likes Received:
    50
    Best Answers:
    0
    Trophy Points:
    88
    #3
    You should first optimize your queries...or atleast run some type of asyncronis remoting service. Sometimes placing your queries in stored procedures does the trick.

    in short...find the time to fix your code. :)
     
    tonyrocks, Apr 3, 2007 IP
  4. tippie

    tippie Peon

    Messages:
    660
    Likes Received:
    13
    Best Answers:
    0
    Trophy Points:
    0
    #4
    or create a my.cnf in /etc/ and search google for the right settings according to your server.
     
    tippie, Apr 4, 2007 IP