Displaying 1 result from an estimated 1 matches for "business_name".
2006 Jan 18
3
search with like operation from a table
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