Learn More
Resend Email
19
coldfury
8y

Admit it. We've all selected * before.

undefined
Favorite
Ranter
Comments
  • 1
    8y
    Take what you want, but eat what you take. Select only the fields you really need.
  • 1
    8y
    @csessh A query might run thousands of times a day, and passing unnecessary data over the network is a wast.
  • 0
    8y
    Production db at work has a lot of select * stored procedures because we always need all of the fields from the tables.
  • 1
    8y
    A lesson learned eventually with many tears. We've had it bad enough where a joined table with multiple text fields overloads the buffer... 😖
  • 1
    8y
    @Seethe My current job's way of thinking: what is a join? Is it tasty?
  • 0
    8y
    @projektaquarius I do not envy you...
  • 0
    8y
    @Seethe me neither.
  • 1
    8y
    I did when I first started, now I put column names cause its easier than pulling up either my text file or phpmyadmin to see what the column names are
devRant © 2021 Hexical Labs LLC
Privacy Policy  |  Terms of Service
Add Comment