search for: undemanding

I have a table with the list of business name and address in it. It may contain 1 million rows. The users want to look up into this table based on the business name. The simple solution is to use LIKE in mysql, but I am worried about performance, since the user load will be very high for this system. Any suggestion on how to handle the potential performance issue? How can i use a search

Hi list I am sad, today! I start to study how windows deal with CIFS, Active Directory and DFS, I just decide follow the other path! I will give a try to windows tools.... The question is: why Linux doesn t have such tools to help and improve server deployments?!? Everything will be easier than go to linux console and try and try and try and nothing happen! So, for now on, I will use Windows