Archive for the ‘sql’ Category

Optimizing PHP & SQL

Commonly we see php being used as an interface between the client and the database providing the information. Very few implementations utilize optimization, and thus, reduce performance. Listed below are many techniques that should be used to optimize php to sql communication.

Do not use SELECT * unless you must
Use SELECT priorities for better control
SELECT [...]