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?

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

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! :thumbsup

I live for dynamic content.

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?

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.

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

http://www.wsjb78.com/wsjb78logo.jpg

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