Page 1 of 1

speed searching rext mysql

Posted: Thu Jul 22, 2004 9:08 am
by CodeEye
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)

Posted: Thu Jul 22, 2004 9:14 am
by liljester
if you dont need your fields to be too terribly big you can use a varchar and index that, but its limitation is 255 characters.