Databases Technology Performance Benefits Of COUNT(*) In SQL November 5, 2016Lance Cleveland This is something I often come across in code. Just came across it in our MySLP project today , in fact. SELECT count(id) FROM my_table While the performance impact of…Continue readingPerformance Benefits Of COUNT(*) In SQL
Databases Development Performance Issues? Check Your Indexes April 7, 2016February 6, 2023Lance Cleveland Any of the tech geeks that have worked for me in the past have heard me say it a million times. “Check your indexes , people!” It is the single-most…Continue readingPerformance Issues? Check Your Indexes