speed searching rext mysql

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
CodeEye
Forum Commoner
Posts: 25
Joined: Fri Jul 05, 2002 7:19 am

speed searching rext mysql

Post 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)
User avatar
liljester
Forum Contributor
Posts: 400
Joined: Tue May 20, 2003 4:49 pm

Post 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.
Post Reply