Alerts

• Different parameter sizes result in inefficient query plan cache usage
  Friday, January 08, 2010
• Alert: Unbounded result set
  Monday, November 09, 2009
• Avoid too many joins
  Saturday, February 20, 2010
• Too many database calls in the same request
  Wednesday, February 23, 2011
• Alert: Too many database calls per session
  Monday, November 09, 2009
• Alert: Too many cache calls per session
  Monday, November 09, 2009
• Too Many Cache Calls In The Same Request
  Thursday, February 24, 2011
• Superfluous update - use inverse='true'
  Monday, November 09, 2009
• Alert: Select N+1 in the same request
  Wednesday, February 23, 2011
• Alert: Select N+1
  Monday, November 09, 2009
• Don’t Query from the View
  Sunday, September 19, 2010
• Alert: Multiple write sessions in the same request
  Wednesday, February 23, 2011
• Alert: More than one session per request
  Wednesday, February 23, 2011
• Alert: Large number of individual writes
  Monday, November 09, 2009
• Alert: Excessive number of rows returned
  Monday, November 09, 2009
• Alter: error was detected
  Monday, November 09, 2009
• Ends with query (like '%...') will force the database to scan the full table
  Wednesday, December 01, 2010
• Alert: Use of implicit transactions is discouraged
  Monday, November 09, 2009
• Queries & data binding shouldn’t mix
  Sunday, September 19, 2010
• Alert: Using a single session in multiple threads is likely a bug
  Monday, November 09, 2009
• Alert: Transaction disposed without explicit rollback / commit
  Monday, November 09, 2009