Skip to content

Today's Card

Software engineering and other thoughts.

Tag Archives: database

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.

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.

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.

Use maps.

They’re a good tool for complex queries.

Posted byfooyayOctober 21, 2020September 29, 2020Posted inUncategorizedTags:database, mapping, queryLeave a comment on Use maps.
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