artfulrobot

187 reputation

bio	website
	location
	age
visits	member for	1 year, 6 months
	seen	May 17 at 14:43
stats	profile views	8

	187 reputation	bio	website		visits	member for	1 year, 6 months
6 badges		location			seen	May 17 at 14:43

summary answers questions tags badges favorites bounties reputation activity

49 Actions

suggestions reviews revisions comments badges posts accepts all

Apr 19	answered	MySQL Full Text search increase relevance for exact matches?
Apr 19	asked	MySQL Full Text search increase relevance for exact matches?
Feb 28	comment	How do I update last row of a group in MySQL The question is specifically about MySQL (hence title, tag), it is a known limitation of MySQL. Thanks anyway.
Feb 27	comment	How do I update last row of a group in MySQL Thank you! That's perfect.
Feb 27	comment	How do I update last row of a group in MySQL Nope, this generates the same error.
Feb 27	comment	How do I update last row of a group in MySQL Thank you. This works well when there are not two records with the same MAX(date). Let's say that's valid data, and that another field is needed to determine the latest one, e.g. sort on date, ID - is there a solution for that too? (feel free to say this is a different question if not simple!)
Feb 27	accepted	How do I update last row of a group in MySQL
Feb 27	asked	How do I update last row of a group in MySQL
Feb 22	accepted	Optimising MySQL query with lots of self-joins
Feb 22	accepted	Efficiency for contact-contact relationships schema
Dec 21	comment	Efficiency for contact-contact relationships schema I did it! See related question and thanks again.
Dec 21	revised	Optimising MySQL query with lots of self-joins added 457 characters in body
Dec 21	comment	Optimising MySQL query with lots of self-joins Thanks, I've edited first line to be clearer. But the question was about optimising the query, not just the join. And I achieved that by 20x, which is good! I'm interested with what you say to try it with a non-covering index (and to try MariaDb without that index), but I suspect the table lookup is what was causing it grief. Will report back if I do these test. Thanks for your help.
Dec 21	revised	Optimising MySQL query with lots of self-joins added 17 characters in body
Dec 20	revised	Optimising MySQL query with lots of self-joins added 119 characters in body
Dec 20	answered	Optimising MySQL query with lots of self-joins
Dec 20	comment	Optimising MySQL query with lots of self-joins Thanks for sharing. Yeah, sort of but it's not limited parent-child implementations. But the question is about optimisation not how-to.
Dec 20	asked	Optimising MySQL query with lots of self-joins
Nov 6	accepted	MySQL replication problem: slave has become out of sync
Nov 6	comment	MySQL replication problem: slave has become out of sync This is just duplicating the entire database and re-setting up the slave relationship, right?