Question about SQL

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • theking
    Nice Kitty
    • Sep 2002
    • 21053

    #1

    Question about SQL

    I have never used an SQL data base before...but I have seen literally hundreds of sites that have SQL errors. Can someone explain why this is. Is it the fault of the server...the programmer...or is SQL shaky?
    When you're running down my country hoss...you're walking on the fighting side of me!

    FOR THE LYING LOWLIFE POSTING AS PATHFINDER...http://gfy.com/fucking-around-and-pr...athfinder.html
  • KC
    Confirmed User
    • Jan 1995
    • 2417

    #2
    Originally posted by theking
    I have never used an SQL data base before...but I have seen literally hundreds of sites that have SQL errors. Can someone explain why this is. Is it the fault of the server...the programmer...or is SQL shaky?
    Most likely caused by shitty programming and/or lack of maintenance. SQL is a powerful class of relational databases. I'd estimate 99% of all interactive sites on the net use some sort of SQL based backend..

    Jupiter Hosting, Inc.
    Vice President, Business Development
    kc (AT) jupiterhosting.com

    Comment

    • LuSiD
      Confirmed User
      • Dec 2002
      • 434

      #3
      Some SQL errors, like "Too many connections," show up all too often, but these are always caused by poor configuration and/or programming. But databases aren't, in general, just "shaky", whether they are MySQL, PostgreSQL, SQL Server, Oracle, blah blah blah... and once you work out the issues you are having, they come in real handy!

      I live for dynamic content.
      I bought a dog the other day... I named him Stay. It's fun to call him... "Come here, Stay! Come here, Stay!" He went insane. Now he just ignores me and keeps typing.

      Comment

      • Mutt
        Too lazy to set a custom title
        • Sep 2002
        • 34431

        #4
        i've always noticed the same thing with dynamic sites using mySQL, GFY included, lots of errors n shit. So it's bush league code that causes it mostly? or server issues?
        I moved my sites to Vacares Hosting. I've saved money, my hair is thicker, lost some weight too! Thanks Sly!

        Comment

        • Samoan
          Confirmed User
          • Aug 2003
          • 203

          #5
          A lot of times, it's the programmer's fault. It's easy to make mistakes when writing programs. One wrong character, and you're screwed.
          Samoan

          Comment

          • wsjb78
            Confirmed User
            • Jun 2002
            • 594

            #6
            I tend to think most of the time the programmer just fucked up and did not optimize the queries if at all...

            However high-traffic sites like this board use a lot of the mysql ressources and you can get errors like too many connections and stuff...

            wsjb78

            __________________
            <br>Check backlinks of your sites
            Get your Daily Google PR list here
            ICQ: 171751720 <--> Wassup with lil2rich4u2 <--> Always looking for new Sponsors

            Comment

            • com
              Confirmed User
              • Aug 2003
              • 4541

              #7
              Go with a good host, and you'll be running on a UNIX (hopefully FreeBSD) platform with MySQL built with compile time options that are made to optimise the database for your specific application. That and a careful eye and you won't have any problems with SQL.

              -Brendan

              Real. Professional. Hosting.
              .:Expect Nothing Less:.
              320-078-843 :: www.realprohosting.com :: [email protected]

              Comment

              Working...