I am trying to produce a website built in mysql i want the navigation system to rely on keywords stored in a text field in the database but mysql wont let me set the collumn as a key, are there any other ways i can impove speed in seaching the key collumn.
I need this search to be fast as possible its my first time using sql rather than storing the info in a xml file so i am new to it. so i may be asking an imposible question.
(i want the site to grow to the content using these key words rather than shaping the content into set catogerys. this is just for a personal site but it want to get it perfect and very fast)
speed searching rext mysql
Moderator: General Moderators