Our website uses Ajax.Autocompleter function for a quick search (http://madrobby.github.com/scriptacu...autocompleter/).
I'd like to be able to capture and log the final search term into a database.
After 3 characters, with each character a user types into the search box, AJAX calls an external/server-side search script to do the search.
To log each time the search script is called (which is every time a character is typed after the 3rd one) would increase the size of the table pretty fast.
I can log the time and look at the time difference that the last time that particular IP called the search script, and UPDATE that row instead of INSERT a new row.
However, if that same IP makes a different search query, I'd like to capture and log both queries.
I don't want to slow down the search any more than necessary with more mysql calls. My db is fairly large as it is (over
I could capture each one then cleaning up the table daily, but am stuck for the mysql query.
Does this make sense?
Does anyone have a slick idea how to best log the search results without logging each character entered?