What is Digg?Sponsored by Guitar Center
When Heavy-handed Hints Fail--Guitar Center Wishlist Posters view!
guitarcenter.com - Cool personalized designs send a friendly reminder that a new Stratocaster would rock, thanks.
26 Comments
- judolphin, on 10/12/2007, -1/+18Nothing like a nice pissing match between coders on Digg.
- resplence, on 10/12/2007, -0/+12Yeah but I thought it would be a humorous post. I hate learning.
- munky100, on 10/12/2007, -0/+8How to ultimately optimize your queries.. cache the page!
- DDoSAttack, on 10/12/2007, -0/+7I would say availability is more of an issue than choice...
MySQL is on every hosting plan you can get these days. PostGres isn't, Oracle definitely not, etc... - mmalone, on 10/12/2007, -1/+7I'd say it's mostly preference, but MySQL actually tends to be faster than these other servers. MySQL was designed specifically to be fast. In order to achieve higher speeds, the development team intentionally left out some features that are common in other database products. It's only recently that MySQL has gained transaction support, subqueries, etc. for example.
Things are changing, and features are being added, but that's the biggest difference. - inactive, on 10/12/2007, -0/+4So what exactly are the advantages of using MySQL to using Oracle 10g Express, DB2 Express, PostGresSQL, or even SQL Server 2k5 Express (all free)? Is there any or is it all preference?
- schestowitz, on 10/12/2007, -2/+6How not to optimize a MySQL query (the Digg.com way):
Log out.
Pages will finally require less than 1000 database queries to be generated. This is especailly true if you have many people flagged as 'friend', which lead to a scalability issue. - SloppyJoe, on 10/12/2007, -0/+3Read it. Good stuff.
- mmalone, on 10/12/2007, -1/+3In case anyone was interested... the load average on my web server right now is around 40. The load average on my MySQL database server is 0.00 :).
To be fair, the web server is a single processor box with 512MB RAM and the DB server is dual processor, dual core, with 2GB, but still... - JonLatane, on 10/12/2007, -0/+2To this day, I see database code from untrained people who don't know how to join tables, even in the FROM statement (much less with a JOIN statement). It hurts my head every time I see it.
- captainpete, on 10/12/2007, -2/+4Properly Index tables, avoid superfluous queries, look for bottlenecks, and learn SQL... Aren't those things you want to do? Did you get past the headline?
- drmangrum, on 10/12/2007, -0/+2If your in an environment where you need to optimize a database for peak performance and you don't know how to do that without reading random blogs, how the hell did you get your job?
- etx313, on 10/12/2007, -1/+3All I heard was Nerdy Nerd Nerdey Nerdnerd.
- SloppyJoe, on 10/12/2007, -1/+3Article summary:
That other article was wrong blah blah blah.. only works for MySQL blah blah blah.
Learn how to do joins. - jlebrech, on 10/12/2007, -3/+5never select *
If your table has too many fields to select them individualy, you've obviously designed your table wrong. - LKBM, on 10/11/2007, -0/+1Maybe I'm trying to learn it before going into such an environment.
- vann, on 10/12/2007, -6/+7My response, with my own 10-point list and rebuttal: http://20bits.com/2007/04/10/10-tips-for-optimizing-mysql-queries-that-dont-suck/
- mmalone, on 10/12/2007, -1/+1You got it!
- batv0r, on 10/12/2007, -1/+1Your blog provides a different angle on solving a problem which is good to those looking for alternatives to their methods of writing SQL and optimizing their db performance.
- Topher06, on 10/12/2007, -2/+1Really this is a glorified Digg comment, not a valid article to submit and comment on. Should make an article "How not to write a blog and post it on Digg" or "Stating the effing obvious".
- rip747, on 10/12/2007, -2/+1@jlebrech
That statement is untrue and I have proven it.
http://rip747.wordpress.com/2006/07/10/to-select-or-not-its-a-matter-of-opinion/ - DigitalJester, on 10/12/2007, -4/+2Simple way to unoptimise it.
Use Microsoft Access. Build Queries using its UI then look at the SQL view. Brackets Galore! - Groovel76, on 10/12/2007, -3/+1How to really optimize your MySQL query? Learn MySQL. No *****!
- inactive, on 10/12/2007, -7/+3WOW that article blew my mind!!!!!!!!!!!!!!11111111111111!!!!!!!!!!11 I never knew there was sooo much to SQL1!!@!@! It's crazzzzzzzzzzzzy. When he tells you that the best way to improve your SQL skillz is to learn SQL fdsafdas WOWOWOWOWOWO I Never THOUGHT TO DO THAT!!!!!!!!!!!
- strictnein, on 10/12/2007, -5/+1"PostGresSQL"
You fail! - Kalan, on 10/12/2007, -12/+2Warning! Blatant self promotion below!
If you are interested in MySQL, visit themysqlguy.com
OK we may resume normal programming....
© Digg Inc. 2009
— Content created and posted by Digg users is