Posted on November 5, 2016Categories Databases, TechnologyTags , , ,   Leave a comment on Performance Benefits Of COUNT(*) In SQL

Performance Benefits Of COUNT(*) In SQL

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 that statement in itself is negligible, it does add up.  For most database engines that statement incurs additional overhead as it processes logic related to a specific column containing a specific data type.   Some database engines check if the column is null for EVERY RECORD, for example.   Not a big … Continue reading “Performance Benefits Of COUNT(*) In SQL”

Posted on August 29, 2016Categories TechnologyTags , , ,   Leave a comment on The FBI Says Two State Elections #Databases Have Already Been Hacked (#SQLInjection #security)

The FBI Says Two State Elections #Databases Have Already Been Hacked (#SQLInjection #security)

This is why you should hire QUALITY developers not “cost saving” developers. SQL Injection attacks are rookie hacker methods. It is one of the most basic forms of hacking. There is ZERO excuse for this from ANY tech company, never mind a government agency. Don’t hire your nephew that just took his first computer class. Don’t hire your sister’s application development firm just because her design company decided they were going to “get into apps”. Hire REAL application developers that … Continue reading “The FBI Says Two State Elections #Databases Have Already Been Hacked (#SQLInjection #security)”