Optimizing MySQL Query

BY IN Tips & Trik Comments Off on Optimizing MySQL Query

Only SELECT the fields you require All to often web developers will SELECT * which selects all fields for a record. However, you’d be surprised how much of a strain SELECT * can cause when running a query, especially on larger tables. So, instead of selecting absolutely everything, just select the fields you need. it

CONTINUE READING …