| bio | website | JudStephenson.com |
|---|---|---|
| location | Brooklyn, NY | |
| age | 24 | |
| visits | member for | 6 months |
| seen | Feb 19 at 22:18 | |
| stats | profile views | 0 |
Programmer, Economist, Trader.
Contact me at Jud (dot) Stephenson - at gmail.
|
Dec 14 |
comment |
Simplify and optimize a complex query "The answer to that is that you either have to try to make more "intelligent" estimates of your hardcoded number 100" I'm not sure what you mean by that. I only want 100 results back, so the limit is 100. Also, we are using InnoDB. I tried using unions instead of the OR predicates, but it didn't help performance. |
|
Dec 14 |
awarded | Editor |
|
Dec 14 |
revised |
Simplify and optimize a complex query added 785 characters in body |
|
Dec 13 |
awarded | Student |
|
Dec 13 |
asked | Simplify and optimize a complex query |
|
Dec 13 |
awarded | Autobiographer |