135 reputation
17
bio website hanseninfotech.com
location Tinton Falls, NJ
age 22
visits member for 2 years, 6 months
seen 6 hours ago

Web and mobile application developer focusing primarily in development on the LAMP stack, Python/Django, and on iOS and Android development. Technology enthusiast who loves to learn about everything and anything. Fluent in English and Spanish.

Specialties:
Web Development
Mobile Development
Systems Administration


Jun
3
awarded  Notable Question
May
12
accepted Optimizing GROUP BY Query
May
12
comment Optimizing GROUP BY Query
Thanks for the explanation!
May
12
comment Optimizing GROUP BY Query
@ypercube that worked! Thanks!
May
11
comment Optimizing GROUP BY Query
@ypercube I'm going to try that and report back.
May
11
comment Optimizing GROUP BY Query
@alexandros, type is actually a stock ticker and they vary in length i.e 'a' and 'goog'.
May
11
asked Optimizing GROUP BY Query
Oct
14
comment MySQL Query Optimization - Indexes & Joins 12 million+ records
that's what i meant. just used the same name. so track_title field without normalization would go in the track table and the track_title table would become track_word and it'll be just an id with one word for example. {id => 10929909, word => "and"}, {id => 10929909, word => "i"}, {id => 10929909, word => "love"}, {id => 10929909, word => "her"} etc...
Oct
13
awarded  Commentator
Oct
13
comment MySQL Query Optimization - Indexes & Joins 12 million+ records
Please see me edit. I thought of an alternative but I'm open to any suggestions other than the wildcard at the start.
Oct
13
comment MySQL Query Optimization - Indexes & Joins 12 million+ records
Definitely does speed up without the first %. Please see me edited question and let me know what you think.
Oct
13
revised MySQL Query Optimization - Indexes & Joins 12 million+ records
more info
Oct
11
revised MySQL Query Optimization - Indexes & Joins 12 million+ records
deleted 223 characters in body
Oct
11
awarded  Editor
Oct
11
comment MySQL Query Optimization - Indexes & Joins 12 million+ records
@SebastianMeine added the table structure with the indexes.
Oct
11
revised MySQL Query Optimization - Indexes & Joins 12 million+ records
added 3201 characters in body
Oct
11
asked MySQL Query Optimization - Indexes & Joins 12 million+ records
Mar
11
awarded  Popular Question
Jul
2
awarded  Supporter
Jul
2
awarded  Scholar