Im just wondering will SQL database be damaged, if you make a lot of queries
for example using ajax live search, as when you add or delete a letter it will make a new query
thank you for you time :)
Your database will not be damaged. Your website may become slow and laggy, not because of DB queries, but because of the many http requests while the user types. To make an effective live search there are a few things you can do:
FULLTEXTindex on the columns you wish to search frequently
WHERE industry='...' AND region='...'to your query and it will run much faster. Anything that will allow you to focus the query.