I've an instant search box on my website that presents options to the user on keyup, it uses AJAX and fetches matching results on keyup. Similar to the search box on amazon.com
It is very common these days but my problem is that I had to set max_user_connections to 200 in my.cnf because mysql user was reaching the connection limit due to traffic. The script opens and closes the database connection properly, but we are expecting more traffic and this too will fail, I believe, this is not the right way to implement instant search but not sure what is that other efficient method?
Looking for experts advice on this.