29
I did some work on mysearch today, I changed the table structure. Now we have 3 tables, one record unique queries(full query), other unique keywords(each word), and the other register the queries by users made and it is linked with the other 2.
I did not implemented yet in index page and in admin area but the autosugestion is already using them. It will be more quick this way and more accurate. Have a look in xuups please.