Best Practices - GlideRecord

• Use the appropriate object methods based on your scope - GlideRecord - Scoped GlideRecord
• Use GlideAggregate instead of getRowCount() for large tables and production instances
• Perform all record queries in server-side scripts for improved performance
• Use _next() and query() for tables containing next and query columns
• When deleting/inserting/updating records with GlideRecord methods, practise writing the list of records to a log to insure you do not accidentally modify records you still need before enabling the methods and modify the database (there is no undo!)