When you say "search in my phpmyadmin" tables, do you really mean search your MySQL database tables? (phpMyAdmin is just a web-based tool for working with MySQL, but presumably your web app would not be using phpMyAdmin, and instead interfacing directly with MySQL.) Assuming that's the case, if it's too slow, it's probably because you have not properly optimized things in terms of DB design, indexing, and query optimization -- and possibly making use of FULLTEXT column indexes using the INNODB table type for searching text columns.
"Please give us a simple answer, so that we don't have to think, because if we think, we might find answers that don't fit the way we want the world to be."
~ Terry Pratchett in Nation
When you say "search in my phpmyadmin" tables, do you really mean search your MySQL database tables? (phpMyAdmin is just a web-based tool for working with MySQL, but presumably your web app would not be using phpMyAdmin, and instead interfacing directly with MySQL.) Assuming that's the case, if it's too slow, it's probably because you have not properly optimized things in terms of DB design, indexing, and query optimization -- and possibly making use of FULLTEXT column indexes using the INNODB table type for searching text columns.
yes i mean mysql database.. sorry for this interruption
but i want to know how to make table indexing in my database??? please advise
In a nutshell, any column that is used in a WHERE, ON, GROUP BY, or ORDER BY clause should have an index on it (index, unique, or primary key). Additionally, MySQL supports a special FULLTEXT index you can use on TEXT columns, and to which you can apply specific functions useful for searching that text: http://dev.mysql.com/doc/refman/5.0/...xt-search.html
"Please give us a simple answer, so that we don't have to think, because if we think, we might find answers that don't fit the way we want the world to be."
~ Terry Pratchett in Nation
Reply With Quote
Originally Posted by NogDog
Bookmarks