Search for XML tutorials : Sorry, no results found

Hello,

I searched for « XML » tutorials (I selected it from the combobox) and got : « Sorry, no results found ».

But we both know that 2 XML tutorials were written for codewalkers .

* PDF new tutorials rock

JM

The search only works for words longer than 3 letters. With all the TLA (Three Letter Acronyms), maybe that should be changed... Matt?

i got 14 results by searching for "extensible markup language"

that would give much bigger mysql table indexes, and somewhat slower search..

I realize the trade off, but maybe it would make sense to do it for just the tutorials.

There is an XML link on the tutorial page...why should the search function be changed if XML tutorials are that easy to find????

I use MySQL fulltext searching. To index 3 character words would require a change to source code and a recompile of MySQL.

This is why I haven't done it in the past. If you really think it should be so, make your arguements here. I will listen to all reasonable arguements .

If you upgrade to 4.0, it's just a variable change, server restart, and index rebuilding. But I remember there were problems all over when you tried to upgrade, so it's probably not worth it. Too bad it's not on a table or index basis instead.

Without knowing the actual size and speed trade-offs that come from changing the length from 4 to 3, and without stats on how many searches are done using useful three letter words (do you log searches?), I don't think I can effectively argue for or against changing it.

I'll run some tests on a machine at work. I'll install MySQL 4 with 4 char minimum and dump in the messages table from the forum. I'll benchmark that. Then I'll decrease to 3 char and rebuild indexes and benchmark that.

Then I'll also benchmark MySQL 3.23 with 4 char minimum and 3 char minimum...

We are running on MySQL 4 now. I set the char limit down to 3. The only gotcha is that searching for XML in tutorials still doesn't work. I store all the tutorials in XML format, so they all contain the work XML in them. MySQL's fulltext search doesn't return results if it matches more than 50% of rows.

Doh!

how about this: you add a separate search column that will have the tutorial text without all the xml tags (striped out with strip_tags()).

so use only text for fulltext searching, but use the original xml code for presentation?

searching tutorials
i searched for "date" and it found no results.
i searched for "dates" - 2 results

date is also a tag in the XML, that is why it brings up no results.

Good idea zombie, I was actually thinking the same myself. I will make it happen in just a little while..

Done.....

that was fast!