Post reply

SQL Performance Elevenses

  • February 17, 2016 at 8:38 am

    #1859278

    Just one comment on number 10

    Elegant SQL often boils down to the same query plan as awkward-looking SQL. Don't be fooled into believing you can make SQL queries run faster by making them more elegant. There is a lot of syntactic sugar in SQL recipes.

    Elegant SQL queries might not run faster, but can be debugged faster. Please, format the code.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

  • February 17, 2016 at 10:06 am

    #1859311

    Luis Cazares (2/17/2016)

    Just one comment on number 10

    Elegant SQL often boils down to the same query plan as awkward-looking SQL. Don't be fooled into believing you can make SQL queries run faster by making them more elegant. There is a lot of syntactic sugar in SQL recipes.

    Elegant SQL queries might not run faster, but can be debugged faster. Please, format the code.

    +1

    Gaz

    -- Stop your grinnin' and drop your linen...they're everywhere!!!

Viewing 2 posts - 16 through 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply