Skip to content

Today's Card

Software engineering and other thoughts.

Tag Archives: performance

Blame the SQL.

Performance problems are often caused by poorly formed SQL statements.

Posted byfooyayOctober 28, 2022October 26, 2022Posted inUncategorizedTags:database, performance, SQLLeave a comment on Blame the SQL.

Mind the 7 P’s.

“Proper planning and preparation prevents piss poor performance.” – British military adage.

Posted byfooyayJanuary 28, 2021December 3, 2020Posted inUncategorizedTags:performance, planning, software architectureLeave a comment on Mind the 7 P’s.

Don’t put queries in loops.

Poorly designed database queries are the leading cause of performance problems.

Posted byfooyayJanuary 26, 2021December 1, 2020Posted inUncategorizedTags:database, performance, SQLLeave a comment on Don’t put queries in loops.

Tighten your loops.

For performance and simplicity.

Posted byfooyayJanuary 6, 2021November 25, 2020Posted inUncategorizedTags:performance, simplicityLeave a comment on Tighten your loops.

Performance tuning is dangerous.

Don’t attempt it unless it’s really going to be necessary.

Posted byfooyayDecember 3, 2020November 12, 2020Posted inUncategorizedTags:performance, tuningLeave a comment on Performance tuning is dangerous.

Keep out of the loop.

This is a simple database optimization many people overlook.

Posted byfooyayOctober 27, 2020September 30, 2020Posted inUncategorizedTags:database, performanceLeave a comment on Keep out of the loop.

Leverage the ORM.

Use relationships to reduce queries.

Posted byfooyayOctober 26, 2020September 30, 2020Posted inUncategorizedTags:Active Record, ORM, performanceLeave a comment on Leverage the ORM.

Use instrumentation.

Don’t try to optimize your application by guessing which part is slow.

Posted byfooyayJuly 31, 2020June 29, 2020Posted inUncategorizedTags:instrumentation, optimization, performanceLeave a comment on Use instrumentation.

Avoid premature optimization.

There’s a time and a place for this and it’s not at the beginning.

Posted byfooyayMay 20, 2020May 10, 2020Posted inUncategorizedTags:optimization, performanceLeave a comment on Avoid premature optimization.
Today's Card, Create a website or blog at WordPress.com
  • Follow Following
    • Today's Card
    • Join 40 other followers
    • Already have a WordPress.com account? Log in now.
    • Today's Card
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar