Welcome to Software Development on Codidact!
Will you help us build our independent community of developers helping developers? We're small and trying to grow. We welcome questions about all aspects of software development, from design to code to QA and more. Got questions? Got answers? Got code you'd like someone to review? Please join us.
Activity for Jack Douglas
Type | On... | Excerpt | Status | Date |
---|---|---|---|---|
Comment | Post #277226 |
An index on `textfield, do_not_touch` will be less efficient than one on just `textfield` because the values in `do_not_touch` are heavily skewed — adding it to the index just means more IO when scaning. (more) |
— | over 4 years ago |
Comment | Post #277216 |
"…leading to a loop or a race": what happens when you add `stopProcessing="true"`? (more) |
— | over 4 years ago |
Edit | Post #277187 | Initial revision | — | over 4 years ago |
Answer | — |
A: Why would excluding records by creating a temporary table of their primary keys be faster than simply excluding by value? > Why would the second way be faster? Generally speaking, the first form will perform worse (as well as looking a lot worse) than the second. You are hitting an edge case where the opposite is true, because: 1. The `not in` in your first example is likely to be transformed into an anti-join (so... (more) |
— | over 4 years ago |
Comment | Post #277148 |
"Every so often I need to join…" — none of your examples have any joins. (more) |
— | over 4 years ago |