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