Timwi wrote:
The performance (as in, speed) is very good.
The implementation is not. It strips away all apostrophes. It is therefore impossible to use categories that contain an apostrophe in their name, e.g. [[Category:Children's literature]]. I am finding it hard to imagine this as an accident; you must have written code explicitly to remove apohstrophes instead of escaping them properly. Why didn't this ring an alarm bell in you? :-p
Thanks Timwi, for taking a look. Sorry, I've got to admit that the implementation was rather hacked together in a hurry. I did indeed write my input cleanup to strip out a lot of characters, cutting with a sword instead of a scalpel. But my main goal was to get the basic functionality out there.
I've also just added a logging routine to collect statistics on it's performance. I'm getting the query, the time to run the query with a limit of 30, and the total number of results available (to look for correlations to large datasets). Any other ideas?
(http://aerik.com/wikintersections.php for anyone that missed it earlier - it runs off a copy of the relevant tables from November.)
Best Regards, Aerik
wikitech-l@lists.wikimedia.org