103 reputation
10
bio website automatem.co
location
age
visits member for 3 years, 3 months
seen Nov 10 at 1:08

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
Mar
26
asked Speed efficient query for membership first joined, latest category from membership table (min, max)
Feb
25
comment Update to session table slow
@Adam yes all gone for this database. There is a second database, which has only about 400 session records at most, I don't think I want to trade another 256M of RAM for that as it happens less often. The amount of actual storage required for the long field is higher than I would have expected, but I think it is worth it.
Feb
24
awarded  Scholar