DEV Community

anhphan
anhphan

Posted on

Query DB SELECT * FROM <table>

SELECT * FROM

; Everyone knows it's been not good, but now I can read the whole bunch of consequences and it's interesting so I'll share it with you guys
  • Increased network traffic
  • Increased CPU usage on client side
  • Some query plan optimizations not possible
  • Server-side memory usage
  • Increased CPU usage on server side
  • Hard parsing/optimization takes more time
  • Cached cursors take more memory in shared pool - LOB Fetching #database.

Top comments (0)

Read next

zhangzhuyue profile image

How to expand the IO number for programmble controller using the self-defined communication protocol

zhuyue -

msnmongare profile image

How to Host a Laravel Project in a Subdirectory on Shared Hosting without Exposing `/public` in the URL

Sospeter Mong'are -

masterhood13 profile image

🚀 New Post: Part 2 of My Dota 2 Match Outcome Predictor Project is Live! 🚀

Viktor Hamretskyi -

varzoeaa profile image

Get The Most From Blade: Laravel's Templating Engine

varzoeaa -