phill.nacelli
Member since Jun 11, 2019
- Profile: /members/13976-phill-nacelli.htm
- URL: http://www.aboutweb.com
- Comments: 2
Recent Blog Comments By phill.nacelli
-
SQL Queries That Look The Same Are Not Violating The DRY Principle
Posted on Jun 12, 2019 at 9:08 AM
@Ben, I ran into this approach once we realized that our database was caching too many prepared statements needlessly, some search queries had multiple possible criteria for custom user dashboards, for example. I always have been a big proponent of letting the database do what is best for,... read more »
-
SQL Queries That Look The Same Are Not Violating The DRY Principle
Posted on Jun 11, 2019 at 10:46 AM
In the example below: <cffunction name="getByFilter" returntype="query"> <cfargument name="id" type="numeric" required="false" /> <cfquery name="local.results"> SELECT id, name... read more »