128 reputation
7
bio website hanseninfotech.com
location Tinton Falls, NJ
age 22
visits member for 1 year, 9 months
seen Nov 13 '13 at 16:51

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


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
Jul
2
comment SELECT TOP in MySQL
Works like a charm! Thanks!
Jul
2
accepted SELECT TOP in MySQL
Jul
2
awarded  Student
Jul
2
comment SELECT TOP in MySQL
@MikaelEriksson You sure that's the easiest way to do it? Seems like overkill. There has to be a simpler way.
Jul
2
comment SELECT TOP in MySQL
@Phil I'll sort them by alphabetical order ascending. Half meaning if I have 80 rows sorted A-Z I want to be able to select the first 40.
Jul
2
comment SELECT TOP in MySQL
@Phil I want half the rows. Basically I want to select the first half and do something with in and then select the 2nd half and do something with it. Which is why i want it to be dynamic. I don't want to store the number of rows and then divide by 2 or anything like that.
Jul
2
awarded  Autobiographer