106 reputation
3
bio website JudStephenson.com
location Brooklyn, NY
age 25
visits member for 1 year, 10 months
seen Oct 15 at 18:36

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