Ajax Querying my Database preventing spam, without a go button

[cooldude832]

I have a page with some categories and a calendar.

 

I want users to be able to update what content is collected without a go button, but I can image querying the database every time a day is toggled is going to lead to DOS errors really quickly.

 

If I put a delay in it users might start to click a million times causing more problems.

 

The content being displayed is some event display boxes, a styled with a 75x75 image in it.

 

Any ideas here how to do this.  I can see it working when the data set is reduced by tracking what is displayed in a JS array and just knocking out items that are no long included.

 

[corbin]

Hrmmm, you can take steps to reduce the frequency of requests, but when it comes down to it having a crap load of requests is essentially in the design of something like that.

 

 

You could try to limit it to 2 request a second or something though.  Also, could make it so that it wouldn't query the DB until the field had stayed the same for a second or something.  (That way everytime the user hits a key a request isn't sent.)