Reputation
Top tag
Next privilege 125 Rep.
Vote down
Badges
10
Impact
~4k people reached

Feb
20
comment Multiple relationships issue
Did you have a chance to dissect it and accept the answer?
Feb
20
accepted Speed efficient query for membership first joined, latest category from membership table (min, max)
Feb
20
accepted MySQL optimize range duplicate query
Nov
10
answered MySQL optimize range duplicate query
Nov
10
comment MySQL optimize range duplicate query
@Manny, tried this, but no change. I did not expect this to hav any effect as existing indexes were already used, but the resultset was still too big
Nov
7
asked MySQL optimize range duplicate query
Jul
1
awarded  Popular Question
Mar
3
awarded  Student
Oct
19
answered Moving large databases
Oct
19
answered Multiple relationships issue
Apr
24
awarded  Tumbleweed
Apr
7
comment Bi-directional replication for the same MySQL table
Can you check if Multi master replication would work? dev.mysql.com/doc/refman/5.1/en/…
Mar
31
awarded  Benefactor
Mar
31
comment Speed efficient query for membership first joined, latest category from membership table (min, max)
InnoDB engine.....
Mar
30
comment Speed efficient query for membership first joined, latest category from membership table (min, max)
fantastic! I have to wait 10 hours to award the bounty
Mar
30
awarded  Commentator
Mar
30
comment Speed efficient query for membership first joined, latest category from membership table (min, max)
Thats what I tried in my original query, can you advise how to link max(start) with the derived table?
Mar
30
comment Speed efficient query for membership first joined, latest category from membership table (min, max)
Thanks, I've come to this conclusion as well. I wondered if there is a way to just use group by and joining the table again. The question is of course will this be faster.
Mar
30
awarded  Promoter
Mar
26
revised Speed efficient query for membership first joined, latest category from membership table (min, max)
edited title