“If your query returns a small number of rows but filters inefficiently, the database might still have to scan a large portion of the table and sort all those matching rows, which involves temporary memory, CPU, and often some significant amount of disk I/O - especially without an index on the field you're ordering by. Keep this in mind when considering whether to sort the results of your query using .orderBy() or .orderByDesc(), and be sure never to do so either willily, or nillily.”
Quote by Tim Woodruff
Work
ServiceNow Development Handbook - 4th Edition: A compendium of ServiceNow "NOW" platform development and architecture pro-tips, guidelines, and best practices
Browse quotes and source details for this work. more
Author
You May Also Like
“When your audience relates to your business’ values, it helps in building an instant connection.”
Source: 17 Reasons Why Businesses Fail :Unscrew Yourself From Business Failure
Source: The Connectworker
Source: Why I'm No Longer Talking to White People About Race
“A perfect metaphor: something important, solemn, while still easy to understand.”
Source: In Limbo
Source: Rethink Everything: You “Know" About Social Media
“Having an inaccurate or incomplete view of ourselves is why are always depressed”
Source: The Orphan Choir
Source: Hankering for Tranquility
Source: Higher Ground: Stevie Wonder, Aretha Franklin, Curtis Mayfield, and the Rise and Fall of American Soul