spacepoet Posted January 30, 2011 Share Posted January 30, 2011 Hi: I have my hosting from GODaddy, and my making tables in mySQL for my small CMS that I use to edit the page content. I have what I think is a error messgae "No index defined" (see attached .JPG). What does this mean? Do I have to define this? The CMS works fine. All it does is update the fields. ?? [attachment deleted by admin] Quote Link to comment Share on other sites More sharing options...
Zurev Posted January 30, 2011 Share Posted January 30, 2011 Hi: I have my hosting from GODaddy, and my making tables in mySQL for my small CMS that I use to edit the page content. I have what I think is a error messgae "No index defined" (see attached .JPG). What does this mean? Do I have to define this? The CMS works fine. All it does is update the fields. ?? If you wanted that table to work in relation to another, the proper field would need an index, for example, a primary key already has an index. Indices work just like they do in the back of a textbook, they help find information faster. So if you're selecting something by it's ID constantly, you may want to make that an index if it's not already. http://www.w3schools.com/sql/sql_create_index.asp Quote Link to comment Share on other sites More sharing options...
jcbones Posted January 30, 2011 Share Posted January 30, 2011 Just don't index things that change on a regular basis, as that will cause the database extra work. It will have to re-write an index, everytime it is changed. Explained here Quote Link to comment Share on other sites More sharing options...
spacepoet Posted January 30, 2011 Author Share Posted January 30, 2011 OK, that explains it! Thanks for clearing that up. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.