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 :)
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:
FULLTEXT
index on the columns you wish to search frequentlyWHERE industry='...' AND region='...'
to your query and it will run much faster. Anything that will allow you to focus the query.