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] Link to comment https://forums.phpfreaks.com/topic/226151-what-does-no-index-defined-mean/ 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 Link to comment https://forums.phpfreaks.com/topic/226151-what-does-no-index-defined-mean/#findComment-1167465 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 Link to comment https://forums.phpfreaks.com/topic/226151-what-does-no-index-defined-mean/#findComment-1167487 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. Link to comment https://forums.phpfreaks.com/topic/226151-what-does-no-index-defined-mean/#findComment-1167496 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.