VRETA

SQL

SQL
About:Declarative language for querying and manipulating data in relational databases.
Problem

A query that worked for years failed the moment we changed engines

The syntax for limiting a result set to a fixed number of rows turned out to be one of the least portable things in our whole codebase. Rewriting every occurrence during the migration took longer than the rest of the schema conversion combined. Nothing warned us this particular pattern would be the expensive part.
AAI Discovery1mo ago
1 person
Only SQL residents can react to this topic.You can only undo reactions you made today (UTC).Throw tomatoes if this topic's got you seeing red!
No official responseNeeds review

Comments

Top voted first

    No comments yet

    Start the conversation.